Доброго времени суток.
Помогите, пожалуйста с запросом.
Есто запрос

drop table if exists ##TempTable; 
create table ##TempTable  (xmlfield nvarchar(max))
insert into ##TempTable
(xmlfield)
select cast((
SELECT   tblProductsNEW.LOCALCODE, tblProductsNEW.FULLNAME, tblBrands.BRANDEXTID, 
tblProductsNEW.BRANDNAME, tblSubBrands.SUBBRANDEXTID, tblProductsNEW.SUBBRANDNAME, 
tblProductsNEW.PACK_QTY, tblCategorys.CATEGORYEXTID, tblProductsNEW.CATEGORYNAME, 
              tblSubCategorys.SUBCATEGORYEXTID, tblProductsNEW.SUBCATEGORYNAME
FROM     tblProductsNEW INNER JOIN
             tblBrands ON tblProductsNEW.BRANDNAME = tblBrands.BRANDNAME INNER JOIN
             tblCategorys ON tblProductsNEW.CATEGORYNAME = tblCategorys.CATEGORYNAME INNER JOIN
             tblSubBrands ON tblProductsNEW.SUBBRANDNAME = tblSubBrands.SUBBRANDNAME INNER JOIN
             tblSubCategorys ON tblProductsNEW.SUBCATEGORYNAME = tblSubCategorys.SUBCATEGORYNAME
for xml raw('LocalProduct'), type, root('LocalProducts')) as nvarchar(max))


update ##TempTable set
    xmlfield = '<ROOT>' + xmlfield + '</ROOT>'

declare @cmdshell nvarchar(4000) = 'bcp "select * from ##TempTable" queryout "E:\Sales_dep\FTP\EFFIE\Out\LocalProducts.xml" -T -c -w -r -t -S "N_NSWIT_SQL\MSSQL2017" -d "PPB_Central"';

EXEC xp_cmdshell @cmdshell

Выдает
<?xml version="1.0"?>

-<ROOT>


-<LocalProducts>

<LocalProduct SUBCATEGORYNAME="БА Напої" SUBCATEGORYEXTID="1" CATEGORYNAME="ж/б" CATEGORYEXTID="1" PACK_QTY="24" SUBBRANDNAME="GOSSER Natur Gold alkoholfrei 0,5 ж/б" SUBBRANDEXTID="1" BRANDNAME="GOSSER" BRANDEXTID="1" FULLNAME="GOSSER Natur Gold alkoholfrei 0,5 ж/б" LOCALCODE="4000000000002532"/>

<LocalProduct SUBCATEGORYNAME="БА Напої" SUBCATEGORYEXTID="1" CATEGORYNAME="ж/б" CATEGORYEXTID="1" PACK_QTY="24" SUBBRANDNAME="ZIPFER Heller 0,5 б/а ж/б" SUBBRANDEXTID="2" BRANDNAME="ZIPFER" BRANDEXTID="2" FULLNAME="ZIPFER Heller 0,5 б/а ж/б" LOCALCODE="4000000000002554"/>

Нужно добавить кодировку, чтобы было

<?xml version="1.0" encoding="UTF-8"?>

-<ROOT>


-<LocalProducts>

<LocalProduct SUBCATEGORYNAME="БА Напої" SUBCATEGORYEXTID="1" CATEGORYNAME="ж/б" CATEGORYEXTID="1" PACK_QTY="24" SUBBRANDNAME="GOSSER Natur Gold alkoholfrei 0,5 ж/б" SUBBRANDEXTID="1" BRANDNAME="GOSSER" BRANDEXTID="1" FULLNAME="GOSSER Natur Gold alkoholfrei 0,5 ж/б" LOCALCODE="4000000000002532"/>

<LocalProduct SUBCATEGORYNAME="БА Напої" SUBCATEGORYEXTID="1" CATEGORYNAME="ж/б" CATEGORYEXTID="1" PACK_QTY="24" SUBBRANDNAME="ZIPFER Heller 0,5 б/а ж/б" SUBBRANDEXTID="2" BRANDNAME="ZIPFER" BRANDEXTID="2" FULLNAME="ZIPFER Heller 0,5 б/а ж/б" LOCALCODE="4000000000002554"/>
Спасибо.