Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-05 : 14:58:19
|
| rob writes "I got the procedure described in the 'Dynamic Cross-Tabs/Pivot Tables' posting by robvolk to work in SQL Server 7. I managed to adapt it a little to suit my own requirements - I think the original didn't write an output table, just displayed the result.My version worked in SQL 7 and still does.We have now got a server using SQL Server 2000 and I can't get the same procedure to work on it. There is a database with identical structure and I used the same call to the procedure.The error looks as though the query text was chopped off at some point, and if you change the number of columns involved in the query,the point of truncation changes. I never managed to simplify it enough to get it to work though.Is there a configurable setting I need to change ?" |
|
|
DataGuru
Starting Member
1 Post |
Posted - 2004-05-26 : 14:34:19
|
| Can you post the code that you used to write it to an output table?Thanks |
 |
|
|
|
|
|
Dynamic Cross-Tabs/Pivot Tables in SQL Server 2000