Append declaration to XML file

Question

Creating XML out of data in Database by calling proc with bcp as

SET @SQL= 'bcp "exec dbo.proc" queryout '+ @FileName +' -w -r -t  -Sdd\SQL2005 -T '

(proc produced below) Everything is fine => creates XML as desired. Now task is to Add Declaration to this XML (<?xml version="1.0" ?>)

How can this be achieved either in below proc or concating XML with other file (containing the declaration)

SELECT  ( SELECT TOP 1
                    ShiftDate AS "ShiftDate",
                    Shift AS "Shift"
          FROM      [TableName]
        FOR
          XML PATH(''),
              TYPE
        ),
        ( SELECT    EquipmentId AS "WasheryProductionDetails/EquipmentCode",
                    'n/a' AS "WasheryProductionDetails/ActivityCode",
                    'n/a' AS "WasheryProductionDetails/ReasonCode",
                    Parentmaterial AS "WasheryProductionDetails/WasheryFeed/MaterialCode",
                    ParentStockpile AS "WasheryProductionDetails/WasheryFeed/ROMStockpileCode",
                    CAST(ParentTonnes AS DECIMAL(18, 4)) AS "WasheryProductionDetails/WasheryFeed/FeedTonnes",
                    ChildMaterial AS "WasheryProductionDetails/WasheryOutput/MaterialCode",
                    ChildStockpile AS "WasheryProductionDetails/WasheryOutput/ProductStockpileCode",
                    CAST(ChildTonnes AS DECIMAL(18, 4)) AS "WasheryProductionDetails/WasheryOutput/ProductTonnes"
          FROM      [TableName]
        FOR
          XML PATH(''),
              TYPE
        )
FOR     XML PATH(''),
            ROOT('WasheryProduction')

Thanks

Answer 1

This page suggests that you need to hard-code the declaration:

SELECT

'<?xml version="1.0" ?>'

+
SELECT  ( SELECT TOP 1
... rest of your code goes here...

EDIT: Changed "UNION ALL" (which was pretty clearly wrong) to "+" (both taken from the linked page.)

Answer 2

Declare @SQL varchar(8000)
Declare @xml xml
Declare @strXML as varchar(max)

set @xml = (select * from for xml path(''))
set @strXML='< ? xml version = "1.0" ? >' + convert(varchar(max), @xml)

select @strXML

set @SQL ='bcp "select '''+@strXML+'''" QueryOut "C:\xmlFile.xml" -r -w -t -T -S '

Exec master..xp_cmdshell @SQL