Home Forums SQL Server 7,2000 T-SQL Pivot query RE: Pivot query

  • March 3, 2010 at 9:23 am

    #1127878

    Check the article in my signature about crosstabs/pivots. It explains how to make a crosstab query which will work in 2000.

    Also, you might want to take a peek at the post on how to provide sample data for future inquiries.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]