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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy