My attached code works exactly the way I need...but
I REALLY need the line
'<xml version="1.0" encoding="UTF-8"/>
To be this
<?xml version="1.0" encoding="UTF-8"?>
But everytime I try that it errors out
Declare @packet varchar(30)
Set @packet = (SELECT '0000' + Cast(CAST(RAND() * 1000000000 AS INT) as varchar) +
Cast(CAST(RAND() * 1000000000 AS INT) as varchar))
Declare @clientAcctNum varchar(10)
Set @clientAcctNum = '00123456'
Declare @clientUserID varchar(10)
Set @clientUserID = '002345'
Declare @contactEmail varchar(30)
Set @contactEmail = 'lbristerg@mydomain.com'
Declare @contactName varchar(50)
Set @contactName = 'Bill Gatesg'
Declare @contactPhone varchar(12)
Set @contactPhone = '(111)222-3333'
declare @xml xml
select @xml = '<xml version="1.0" encoding="UTF-8"/>
<Document>
<XMLVersion Version="2.00"/>
<Header>
<PacketNum>' + @packet + '</PacketNum>
<Test Choice="No"/>
<ClientAccountID>' + @clientAcctNum + '</ClientAccountID>
<ClientUserID>' + @clientUserID + '</ClientUserID>
<ContactEmail>' + @contactEmail + '</ContactEmail>
<ContactName>' + @contactName + '</ContactName>
<ContactPhone>' + @contactPhone + '</ContactPhone>
<SourceID/>
</Header>'
+ (
select top 1
id,
firstName 'Debtors/Names/IndividualName/FirstName',
lastName 'Debtors/Names/IndividualName/LastName'
from
r_users
for xml path('Record')
) + '
</Document>'
select @xml
Open in new window
Open in new window