How can we help you today? How can we help you today?

BUG SQL Promt 9.0.2.3223 On Formatting SQL code

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 ;
rudymm
0

Comments

2 comments

Sort by
  • 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

    FabiolaB
    0
  • 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
    Michael Clark
    0

Add comment

Please sign in to leave a comment.