Cross Tab Query with SQL 2000

[testeng]

Can SQL SERVER do CrossTab Querys like MS ACESS can? I had 2 queries that I did in ACCESS the first one retrieved all the data and the second one put it into a cross tab that filled an array. I cut and pasted the first query into a view in SQL2000 that did the first query but could not cut and past the cross tab query into a view. So does anybody know how that is done?
Thanks for your help

 

[tlbroadbent]

SQL Server doesn't have a crosstab query. There are some techniques available. Check the following.

http://www.fawcette.com/archives/premier/mgznarch/vbpj/2001/10oct01/sqlpro0110/rj0110/rj0110-2.asp

http://www.fawcette.com/archives/premier/mgznarch/vbpj/2001/10oct01/sqlpro0110/rj0110/rj0110-1.asp

http://www.sqlteam.com/item.asp?ItemID=2955

http://www.swynk.com/downloads/sp_cross.sql

http://www.winscriptingsolutions.com/Articles/Index.cfm?ArticleID=23162

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.