I'm parsing with flash a XML file generated by this code:
:XML ON USE MyDatabaseName GO SET NOCOUNT ON SELECT * FROM ProgramacionDia as programa order by hora FOR XML AUTO, ROOT ('toflash'), ELEMENTS SET NOCOUNT OFF
But I get a XML file with the first line empty. Removing this first empty line in the generated XML works ok with flash, but with the generated XML no.
How can I remove that line? Is my script wrong? I have no much idea about this code.
I'm running SQL Server 9.0.