Alignment

torsten.strauss

Hi Redgate Team,

SQL Prompt will format the follow code like this :

[code]

SELECT *
FROM tfu
WHERE
    tfu.TYPE_FUNCTION_NAME IN (N'RESOURCES', N'BUSINESSES', N'ENVIRONMENTS'
                                                            ,  N'FACILITIES', N'SUPPLIERS'
                              );

[/code]

So as you can see the second line in the IN clausel is not aligned.

Thanks for fixing this!

Torsten

MVP

Tianjiao_Li

Hi @torsten.strauss

Can you share your format style as well? Which version of Prompt you've installed?

torsten.strauss

Hi Tianjiao,

Version is 9.2.8.6358

Style is attached...

Tianjiao_Li

Hi @torsten.strauss

Thanks for your help! I have reproduced it in 9.2.9. 

This issue is logged as SP-7234 in our internal bug tracking system now. Please keep an eye on the release note!

TomW

Hi Torsten,

We've just reviewed this bug using the latest version of SQL Prompt with your styles, and the issue no longer seems to occur.

Please let us know if you have any other issues.

Thanks,

Tom

torsten.strauss

Hi Tom,

thanks for the update.
It looks much better now!

Torsten

TomW

Glad to hear it Torsten!