Crosstab in SQL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does any one know what the equivalent command is in standards SQL to build a
crosstab query? In Access it starts with TRANSFORM but I can't find that in
any of the online books for SQL Query Analyzer.

Thanks,
Anthony
 
Hi,


Another possibility, pointed out long ago by Mary Chipman, is to use a
linked server, from MS SQL Server. Indeed, MS SQL Server allows you to use
different database engines while solving a (one) query, and one of these
servers can be Jet. And, to complete the loop, Jet allows you to reach the
initial data through a linked table. So, in short, MS SQL Server can use a
linked server to execute the "TRANSFROM ... " statement, and Jet does it
looking back at the original data contained in the MS SQL Server table. For
speed and performance considerations, it is preferable to have JET on the MS
SQL Server server machine.

MS SQL Server 2005 has (will have) the possibility to make static
crosstabs (those with an explicit IN( list ), in Access-Jet), and to UNDO
them too (rather than using a tedious sequence of UNION ALL).




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top