Options

SQL Prompt is not formatting IF statement correctly

BrienKingBrienKing Posts: 30 Bronze 3
in SQL Prompt
The following SQL is not formatted correct.

IF @CalculateHeld = 'Yes' BEGIN
SELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0
DROP TABLE [#HeldFunds]
END ELSE BEGIN
SELECT * FROM [#HeldFunds2] WHERE [HeldAmount] > 0
DROP TABLE [#HeldFunds2]
END

--
Brien King
brien@classicsoft.com
Tagged:
· Share on Twitter

Answers

  • Options
    Matthew_SontumMatthew_Sontum Posts: 26 Bronze 1
    Do you mean that everything inside the BEGIN and END blocks has no indentation? I have been seeing this as well.
    · Share on Twitter
  • Options
    BrienKingBrienKing Posts: 30 Bronze 3
    Correct
    --
    Brien King
    brien@classicsoft.com
    · Share on Twitter
  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    When you say its not formatting "correctly" - how do you think it should be being formatted?

    If I use default_lowercase on 9.2.9 I get this result with indentations:


    If you're not on the latest version trying updating and test again.
    Have you visited our Help Centre?
    · Share on Twitter
  • Options
    BrienKingBrienKing Posts: 30 Bronze 3
    I am on the latest (9.2.9.6459) and it wasn't formatting correctly on the previous version.  In the previous version it was basically the opposite problem where everything was spread way out.

    In this version everything is all left justified.

    This is what is looks like after being formatted:

    IF @CalculateHeld = 'Yes' BEGIN
    SELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0
    DROP TABLE [#HeldFunds]
    END ELSE BEGIN
    SELECT * FROM [#HeldFunds2] WHERE [HeldAmount] > 0
    DROP TABLE [#HeldFunds2]
    END

    What it should look like is this:

    IF @CalculateHeld = 'Yes' BEGIN
    ...SELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0
    ...DROP TABLE [#HeldFunds]
    END ELSE BEGIN
    ...SELECT * FROM [#HeldFunds2] WHERE [HeldAmount] > 0
    ...DROP TABLE [#HeldFunds2]
    END


    --
    Brien King
    brien@classicsoft.com
    · Share on Twitter
  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    Are you using a default style or a custom style?
    Have you visited our Help Centre?
    · Share on Twitter
  • Options
    way0utwestway0utwest Posts: 313 Rose Gold 1
    With my style, I get this:

    IF @CalculateHeld = 'Yes'BEGIN    SELECT *    FROM [#HeldFunds]    WHERE [HeldAmount] > 0;    DROP TABLE [#HeldFunds];END;ELSEBEGIN    SELECT *    FROM [#HeldFunds2]    WHERE [HeldAmount] > 0;    DROP TABLE [#HeldFunds2];END;

    What I'd suggest is look at the whitespace and the control flow sections. Watch out for checking the "wrap if longer than" items. I've had some strange behavior here when these are applied with certain values.
    Editor, SQLServerCentral
    · Share on Twitter
Sign In or Register to comment.