Crosstab in SQL 2000./.net 2003

Hi al

Don't know this is the right forum, but here is my question anyway

Is there a way to make a crosstab like you can in access with the transform statement

Regards

Remco

Not easily you have to build some dynamic SQL, if you do a search on crosstab and SQL server you should come across a number of scripts|||

SimonSa wrote:

Not easily you have to build some dynamic SQL

that is just crazy

remco

|||Thats why its been added into SQL 2005|||

Check out:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=249991&SiteID=1

HTH

|||

Ok tnx (sight)

Remc

|||

Please update post to answered if that answered your question