FOR clause formatting odd...

atompkins

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

SET @cmd = ( SELECT	sg.Column0 + @crlf
							 FROM	dbo.staging_generic sg
							 WHERE	sg.RowNumber > 1
							 FOR	XML	PATH('')
		 						  , TYPE 
						).value('.', 'VARCHAR(MAX)')

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.

James B

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.