BUG SQL Promt 9.0.2.3223 On Formatting SQL code

rudymm

Here is an example of the code:

SELECT 
somez = (
	SELECT 'val1'	AS 'v1'
	, 'val2'		AS 'v2'
	, 'val3'		AS 'v3'
	FOR XML PATH(''), TYPE)

After trying to format it I get:

SELECT 
(
	SELECT 'val1'	S  as v1
	, 'val2'		S  as v2
	, 'val3'		S  as v3
	FOR XML PATH(''), TYPE) as somez ;

FabiolaB

Hi @rudymm,

Thank you for reporting this issue.
I've managed to reproduce the problem locally and I've created a bug (reference: SP-6737) to track it.

Regards,
Fabiola

Michael Clark

Hi @rudymm,

I'm pleased to report that we have fixed this issue in today's release of SQL Prompt 9.0.6.3580.

Download SQL Prompt 9.0.6.3580

Best wishes,

Michael