Results 1 to 2 of 2

Thread: Mixing up data

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Mixing up data

    Hi everyone, I am a bit new to SQL so bare with me.

    I have a table with loads of names in and I need to jumble them up. ie. Need to move one surname to one record and move that surname in to another record.

    My mate mentioned using a cusor, any ideas?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i'll keep my clothes on, thanks

    can you please elaborate what "move one surname to one record and move that surname in to another record" means

    do you want to do this for just one surname? and which other record?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •