Click here to Skip to main content
15,892,005 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi , I Have A really serious Problem , I have A Query Like This :
SQL
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...
Posted
Comments
Zoltán Zörgő 17-May-12 4:20am    
ASP or ASP.NET? If you have the result you want, what is the problem? What is your code you trying to use to save the file? What is the error message or the result you get?

 
Share this answer
 
I checked The Link Before ,
I don't have Problem with Creating the XML Structure in SQL,
I wanna Save The XML I Created with Query and Use it ,
I wait for your Helps ... Thx
 
Share this answer
 
Comments
Zoltán Zörgő 17-May-12 6:54am    
Please post your problematic code here, so we can help you!
Ehsan Sabour 17-May-12 8:22am    
This Query create a XML File in temp Folder ,but I need to save that in a specific File and Use it in My ASP.Net Project .

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900