How to?

• Mr J

  Hall of Fame

  Points: 3595

  More actions

  February 19, 2009 at 3:49 pm

  #131138

  Hello,

  I was wondering if anyone knows how to insert data from

  table A

  [Country],

  [State],

  [ID],

  [2008],

  [2009],

  [2010]

  schema into

  table B

  [Country],

  [State] ,

  [ID],

  [Year], -- being the column heading of 2008, 2009 or 2010

  [YearValue], -- the data contained in column for the respective year

  I'm a bit stuck on this one

  Cheers 🙂

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

• andrewd.smith

  SSCrazy Eights

  Points: 8444

  More actions

  February 19, 2009 at 3:58 pm

  #947228

  Investigate the UNPIVOT clause in Books Online.

• Bruce W Cassidy

  SSChampion

  Points: 12668

  More actions

  February 19, 2009 at 3:58 pm

  #947229

  [font="Verdana"]Have you had a look at the UNPIVOT command on SQL Server Books Online? I suspect that would do what you want.[/font]

• Mr J

  Hall of Fame

  Points: 3595

  More actions

  February 19, 2009 at 3:59 pm

  #947230

  Thanks for the heads up 🙂

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 19, 2009 at 4:00 pm

  #947231

  Mr J (2/19/2009)

  ---

  Hello,

  I was wondering if anyone knows how to insert data from

  table A

  [Country],

  [State],

  [ID],

  [2008],

  [2009],

  [2010]

  schema into

  table B

  [Country],

  [State] ,

  [ID],

  [Year], -- being the column heading of 2008, 2009 or 2010

  [YearValue], -- the data contained in column for the respective year

  I'm a bit stuck on this one

  Cheers 🙂

  insert into dbo.tableB

  select

  [Country],

  [State],

  [ID],

  2008,

  [2008]

  from

  dbo.tableA

  union all

  select

  [Country],

  [State],

  [ID],

  2009,

  [2009]

  from

  dbo.tableA

  union all

  select

  [Country],

  [State],

  [ID],

  2010,

  [2010]

  from

  dbo.tableA

• Mr J

  Hall of Fame

  Points: 3595

  More actions

  February 19, 2009 at 4:02 pm

  #947234

  Sweet very cool 😀

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!