Enmanuel,

It's nor clear what you want to be returned. You can choose between XML and a recordset but not both.

>Hi all, I'm relatively new to SQL Server and I'm wondering how can I store the results from a SQL query into a XML file. Anyone can help me with this one? I know the "TO XML" clause of the SELECT statement but I want to be able to save the returned records to disk.
>
>
>
>
>ooopsss looks like I screw up! Can somebody please move this thread to the SQL Server forum?