Comments posted to this topic are about the item Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS
Hall of Fame
The approach presented works well for a single client. I'm not sure how it would work in the current format if multiple clients needed to be shown. Something like this would work well for multiple clients.
from dbo.sales s
where s.clientid = c.clientid
for xml path ('Sale'), type
) as Sales,
for xml path ('Vendor'), type
from dbo.clients c
for xml path ('Clients'), root ('ClientOrders')
In the next article out next Wednesday I create an SSIS package that emails/ftps invoices to individual customers. That's why I wrote it for one customer at a time.
Viewing 5 posts - 1 through 4 (of 4 total)