What are the challenges you face when working across database platforms? Take the survey
Options

FOR clause formatting odd...

atompkinsatompkins Posts: 22 Bronze 2
edited March 28, 2012 3:55PM in SQL Prompt Previous Versions
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.

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.