How to show the column wise data into row wise

• ganny

  Mr or Mrs. 500

  Points: 531

  More actions

  July 23, 2008 at 8:55 am

  #93684

  Hi,

  i want to show the column data in row wise, can any one please help me how to write a query for this?

  assume data in table like below:

  NameMonth Amount

  ------ -------

  Jun-08 100

  Feb-08 150

  Mar-08 200

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  July 23, 2008 at 9:05 am

  #847119

  Duplicate thread. Please respond here http://www.sqlservercentral.com/Forums/Topic539362-145-1.aspx

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]