Query Help

• *Prashant Thakwani

  SSCommitted

  Points: 1827

  More actions

  March 24, 2004 at 12:44 am

  #160662

  I have the following table schema

  ReportCounty ( ID, ReportID, CountyID, Price )

  Now i want the following output

  ReportID          County1          Couty2           Couty3 ......

  1                       Price             Price              Price

  2                        Price             Price              Price

  3                       Price                Price           Price

  So on.

  Pls help me in making the query

  Prashant Thakwanithakwani_prashant@yahoo.co.in

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 24, 2004 at 6:08 am

  #500195

  Please do not cross post. As most users use the Active thread option you generally will be seen with one post. See/Leave responses in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107882