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

Query Formatting - Error Laying Out SQL message

Hello Redgate. Using SQL Prompt V7.3.0.775, when I attempt to reformat the following code, I get an 'Error laying out SQL' dialog box.
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) a(n)
    CROSS JOIN (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) b(n);

The error appears to be related to the CROSS JOIN. Is this a known issue?

Thanks.
PhilParkin
0

Comments

1 comment

Sort by
  • Michael Clark
    Hi Phil,

    I couldn't reproduce your problem running on the latest version of SQL Prompt. When I execute "Format SQL" I am given:
    SELECT  ROW_NUMBER() OVER ( ORDER BY ( SELECT   NULL
                                         ) )
    FROM    ( VALUES ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0),
            ( 0) ) a ( n )
                     CROSS JOIN ( VALUES ( 0), ( 0), ( 0), ( 0), ( 0), ( 0),
            ( 0), ( 0), ( 0), ( 0) ) b ( n );

    Would it be possible to upgrade to SQL Prompt 7.4 beta and try again?

    Are you using our new experimental formatter?

    Thanks,
    Michael
    Michael Clark
    0

Add comment

Please sign in to leave a comment.