for xml auto 1

[jamert]

Hi I have procedure that has a few joins and at the end of the statement after the where clause i have for xml auto. In QA (sql2k) i ran the proc and returned only part of the xml:
<TestDB.dbo.polls><Question>Do you smoke?</Question><TestDB.dbo.Prev><Points>5</Points><PrevalenceValue>2.2222</Pre><TestDB.dbo.Answers><Label>I used to smoke cigarettes, but I quit </Label></TestDB.dbo.An

it seems to format only 1 record of the many and dies on trying the second record, any thoughts, obviously i am using xml auto incorrectly, as this is my first time

Thanks

 

[gmmastros]

By default, Query Analyzer will only return the first 256 characters. You can easily change this.

Click Tools->Options
Click Results tab
change 'Maximum Characters Per Column'

This may not resolve your problem, but it is the first place I would look.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[jamert]

thanks for the tad of info

 

[gmmastros]

Did it help?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom