Cross-Tab / pivot table query for SQL 7

[EdMacDonald]

I would like to perform the equivalent of an MS Access cross tab query in SQL server 7 where the values of a chosen field become fields of the the result set.<br><br>Is this in anyone's bag 'o tricks?<br><br>Thanks,<br><br>Ed<br><br>

 

[grad]

How many records are you looking at retrieving?&nbsp;&nbsp;I have done this but using Excel to create a pivot table and it is much much more flexible than writing the CT query.<br><br>basically you retrieve all of the data from SQL into Microsoft Excel and you can give it to the users and they can write all the cross tabs they want without bothering you or anyone else.<br><br>It is really slick!<br><br>You can contact me at <A HREF="mailto:mfungafat@mms.org">mfungafat@mms.org</A>