Cross Tab Query

[nickiii]

Does anyone have suggestions on how to create a cross tab using T-SQL? I've searched around and all I can find are stored procs that use global temp tables in creating the query. Meaning, it can only be accessed by one user at a time. My data will be displayed on a web page so there will be concurrent connections.


This is driving me nutts! :confused:

Thanks!