Make rows columns in sql server 2005

• bladerunner148

  SSCommitted

  Points: 1824

  More actions

  January 14, 2010 at 9:42 am

  #1103732

  I think I got to a point where I can display the result by date.

  SELECT[1/7/2009],

  [1/9/2009],

  [1/11/2009],

  [1/13/2009],

  [1/15/2009]

  FROM(SELECT[Date],

  [Count],

  MediaBuyer

  FROM#t

  ) p PIVOT (SUM([Count])

  FOR [Date]

  IN ([1/7/2009], [1/9/2009], [1/11/2009], [1/13/2009], [1/15/2009])

  ) As pvt

  I have one other column MediaBuyer which I cannot find a way to nest that inside here.

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  January 14, 2010 at 11:41 am

  #1103823

  You're almos there.....

  SELECT MediaBuyer,

  [1/7/2009],

  [1/9/2009],

  [1/11/2009],

  [1/13/2009],

  [1/15/2009]

  FROM (

  SELECT [Date],

  [Count],

  MediaBuyer

  FROM #t

  ) p

  PIVOT (

  SUM([Count])

  FOR [Date] IN ([1/7/2009], [1/9/2009], [1/11/2009], [1/13/2009], [1/15/2009])

  ) As pvt

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

• bladerunner148

  SSCommitted

  Points: 1824

  More actions

  January 14, 2010 at 1:16 pm

  #1103891

  Thanks John! I found an article on codeproject which helped me a lot. But thanks for your help too.

  http://www.codeproject.com/KB/database/Pivot2Columns.aspx

  Sid