March 28, 2012 at 12:05 am
Comments posted to this topic are about the item Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS
March 28, 2012 at 6:22 am
Nice article...thanks.
- Chris
March 28, 2012 at 6:24 am
March 30, 2012 at 6:25 am
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.
select *,
(
select *
from dbo.sales s
where s.clientid = c.clientid
for xml path ('Sale'), type
) as Sales,
(
select *
from dbo.vendor
for xml path ('Vendor'), type
)
from dbo.clients c
for xml path ('Clients'), root ('ClientOrders')
March 30, 2012 at 1:08 pm
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)
You must be logged in to reply to this topic. Login to reply