Rows to Columns... help

Results 1 to 2 of 2

Thread: Rows to Columns... help

  1. #1
    B Ellertson Guest

    Default Rows to Columns... help

    what is the optimal way to insert rows of a single column selection into columns of another record?

  2. #2
    Join Date
    Dec 1969

    Default Are you asking this??

    Update tablename set columnname = (select columnname from tablename where Id = ...) where Id = ....<BR><BR>I have used **Id** as just a reference, you might wanna use the Unique field from your table in the where clause. The "Select" is to pick up the "To Be Replaced By - value", the outside "where" clause is to specify which record is to be replaced.<BR><BR>Is this what you are looking for?

Posting Permissions

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