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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Please Help with Generic Reports using XML/XSLT

Author  Topic  guldan Starting Member 1 Post Posted - 2004-10-08 : 04:35:37 A lot of our reports are grab some data using ASP/ADO and run through the results and output a table. I'd like to try and move this to XML and XSLT as a test for doing more later with it. We're using SQL Server 2000 and ASP (not .net) and the main problem I have is in how to get some generic output that the XSLT can process. I was thinking something like : <row><col blah /><col blah /> ...</row><row><col blah /><col blah /> ...</row>... However using SQLXML it seems that I'd need to either create a table wiht col names and join on the data with that or do for the number of columns, that many union alls between XML queries. So essentially things become very unmaintainable in the SQL. Has anyone tackled this issue of outputting in <row><col></row> format or another way to generate generic tables from report like data. Thanks Aaron