>From a previous post of mine on the asp 15seconds list:
You can use a CROSS JOIN for that. Here is a simplistic way to do this:
select
"tables"."xml"
, "table"."name"
, "column"."name"
from
sysobjects "table"
inner join
syscolumns "column" on "table"."id" = "column"."id"
cr
t; Subject: SQL Server xml and SQLDataReader
>
>
> I have a stored proc in SQL Server 2000 that returns data in an xml
> structure. I was hoping that I could read the results
> directly into an xml
> document in ASP.Net
>
> Such as ---
>
> 1)
> Select D
I have a stored proc in SQL Server 2000 that returns data in an xml
structure. I was hoping that I could read the results directly into an xml
document in ASP.Net
Such as ---
1)
Select Date,Time,Vendor,Amount From History For Xml Auto, Elements
2) ASP.Net page
SqlDataReader SqlDataResults
