Very cool. Thanks!

Thanks for the help opc.three. I've been able to create the XML file with the headers I need.

I do have to ask why doesn't oledb connection work and ado.net...

Understood the point in your first paragraph on a high level 🙂

Understood your second point the hard way. Initially, I had the OLEDbConnection for ExecuteSQLTask and after trying...

Pretty cool stuff...

So I think what you're saying is that even though SSMS has the limitation of truncating the XML when showing the results in grid or text (what you're...

I'm not using SSIS right now. I was asking if I could use it to add the xml headers.

For more information about the truncation you can search on google...

I went down the road of trying to convert the xml to nvarchar(max) by following some google links, but when I set the xml to nvarchar(max) some of the xml...

GSquared - Tried that link. For some reason XMLNAMESPACES isn't being picked up as a keyword in the SSMS version that I'm using.

opc.three - The downstream system needs that...

Unfortunately, I can't post any data. With the help of a co-worker I got the proper XML tree structure.

SELECT Portfolios.CountOfPortfolioGroupObjects

,Portfolios.CountOfPortfolioObjects

--Portfolio

,(SELECT EffectiveDate

,RTRIM(PortfolioCode) PortfolioCode

,PortfolioGroup

,IntlDomInd

FROM @Portfolio...

Good catch 🙂

I've advanced further from my last post, but it's a pain to produce an xml nested tree out of sql. What's considered the best practice to produce...

Thanks for the reply.

The data isn't that large so not sure the reason for the error. The first query doesn't give me that error.

Is there an article that shows how to do this for Office 2007?

Gail, why would you get duplicate rows?

Already asked Business if I could do it that way and the answer was no. They want to see it the way below for comparison purposes:

Company 1

Table 1

Table 2

Table...

1) Right Click on the header field (i.e., Product ID)

2) Choose Properties

3) Click on the Interactive Sort tab

4) Check the "Add an interactive sort action to this textbox"

5) In the...

Seajoker: Highlight each column and set the FixedHeader property to True.