Report

• rs

  SSCrazy

  Points: 2819

  More actions

  January 21, 2004 at 3:58 pm

  #160603

  I have a table like this

  DATE            COLUMN-A     COLUMN-B     COLUMN-C

  01/12/2004      23                 25               76

  01/13/2004      12.12             34.234         56

  01/14/2004      12                 24               46

  01/15/2004      26                255              12.3

  My requirment is, need to generate a report with SQL statement as follow's

                    01/12/2004    01/13/2004     01/14/2004   01/15/2004

  COLUMN-A     23                 12.12              12               26

  COLUMN-B     25                 34.234             24              255

  COLUMN-C     76                 56                   46             12.3

  Thanks in Advance.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 22, 2004 at 1:02 am

  #491068

  Mabye Jonathan's reply here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=96509 will help you. There is also an example in BOL. Search for pivot table.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]