Can we use the SQL 2005 engine for queries against a SQL 2000 linked server?

\ by

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

Comments are closed.

Post Navigation