Hello - I am attempting to figure out how to output a sql2005 query into xml & starting with this example from the site - http://msdn.microsoft.com/en-us/library/ms345137(v=sql.90).aspx,
but running into the error - An object or column name is missing or empty.
Can someone tell me what I'm missing? Thanks!!
Here is what I have so far:
select campaign_name as '@Campaign_Name'
(select Campaign_ID as '@Campaign_ID'
where sfrefunds2.activity_quuid = sfrefunds1.activity_quuid
for xml path ('xmlTest'), type),
(select distinct identifier as '@Identifier'
join sfrefunds2 on sfrefunds2.activity_quuid = sfrefunds3.activity_quuid
where sfrefunds1.activity_quuid = sfrefunds2.activity_quuid
for xml path('xmlTest2'), type)
for xml path('xmlTest1')
View Complete Post