FOR clause formatting odd...
I am seeing a FOR clause get some odd formatting.
My code is:
The FOR clause should line up with the SELECT not the SET.
I don't think the ).value is being formatted at all.
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
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.
Redgate Software