DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL query to merge columns into single column in another table

  1. 06-22-2009, 01:37 PM #1
    axn2indya
    axn2indya is offline Junior Member
    Join Date
    Jun 2009
    Posts
    1

    SQL query to merge columns into single column in another table

    HI EVERYBODY,

    please advise a query for the below,

    I have a table like this

    US UK India
    sales 100 50 55

    my updated table shld be like this

    sales US 100
    sales UK 50
    sales india 55

    please guide me...
    Reply With Quote Reply With Quote
  2. 06-22-2009, 02:05 PM #2
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can do the insert with a trigger, but to switch the columns to rows you need a pivot query.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width