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

Alignment

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

torsten.strauss
0

Comments

6 comments

Sort by
  • Tianjiao_Li
    Hi @torsten.strauss

    Can you share your format style as well? Which version of Prompt you've installed?
    Tianjiao_Li
    0
  • torsten.strauss
    Hi Tianjiao,

    Version is 9.2.8.6358
    Style is attached...

    torsten.strauss
    0
  • 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!
    Tianjiao_Li
    0
  • 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
    TomW
    0
  • torsten.strauss
    Hi Tom,

    thanks for the update.
    It looks much better now!

    Torsten
    torsten.strauss
    0
  • TomW
    Glad to hear it Torsten! :smile:

    TomW
    0

Add comment

Please sign in to leave a comment.