Hi , I Have A really serious Problem , I have A Query Like This :
select
(
Select (
Select TColum From Table For XML Path(''), type
)
FOR XML PATH(''),
ROOT('categories')
,Type
)
,
(
Select (
Select
(
Select @S1 for xml path(''),type
)
For xml path (''),
ROOT('Name')
,type
)
,
(
Select
(
SELECT TColum2 as point FROM Table2 FOR XML PATH('') ,type
) FOR xml path ('') ,ROOT('data'),type
)
For xml path (''),
ROOT('Series')
,type
)
,
(
Select (
Select
(
Select @S2 for xml path(''),type
)
For xml path (''),
ROOT('Name')
,type
)
,
(
Select
(
SELECT Colum3 as point FROM Table2 FOR XML PATH('') ,type
) FOR xml path ('') ,ROOT('data'),type
)
For xml path (''),
ROOT('Series')
,type
)
This Query , Make The XML format I Need, But I want To Save This Result in A File , In my ASP Project ,
Thanks Bros...