You bet!

  1. On your SQL 2005/8 instance create a linked SQL 2000 server
  2. Run your SQL 2005 query using something like PIVOT or UNPIVOT against the SQL 2000 linked server table.
SELECT  [ND],
        [SD],
        [TN],
        [OR],
        [VA]
FROM    (
         SELECT State,
                SalesAmt
         FROM   sqltest.northwind.dbo.Sales
        ) p PIVOT ( SUM(SalesAmt) FOR State IN ([ND], [SD], [TN], [OR], [VA]) ) AS pvt
 
Here's a link to an article example about PIVOT, UNPIVOT.
 

Posted in: SQL  Tags:

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010 The SQL DBA