FOR clause formatting odd...

I am seeing a FOR clause get some odd formatting.
My code is:

SET @cmd = &#40; SELECT	sg.Column0 + @crlf
							 FROM	dbo.staging_generic sg
							 WHERE	sg.RowNumber &gt; 1
							 FOR	XML	PATH&#40;''&#41;
		 						  , TYPE 
						&#41;.value&#40;'.', 'VARCHAR&#40;MAX&#41;'&#41;

I can't seem to make it look right on the forum. If you format it in SSMS you'll see what I mean.
The FOR clause should line up with the SELECT not the SET.
I don't think the ).value is being formatted at all.

atompkins March 27, 2012 07:22

Comments

1 comment

Thanks for your post.

I do see the same as you- I've logged it for the Prompt team to take a look at under reference SP-4355 although I don't know when it's likely to get resolved right now unfortunately.
We'll post back here when there's an update.

James B March 28, 2012 15:55

0

Add comment

Please sign in to leave a comment.

How can we help you today?

FOR clause formatting odd...

Comments

Add comment