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

Formatting inconsistency

Hi, I've just upgraded to version 4 and I'm having a problem with inconsistent formatting.

Here's a code snippet...


BEGIN
IF @ReturnWhat = 5
BEGIN
SELECT *
FROM dbo.LatestNonEditRDTheme
WHERE RDThemeMasterID = @EntityMasterid AND
StatusID = 81 AND
RDThemeMasterID IN ( SELECT EntityID
FROM vUserCanViewFinal
WHERE userID = @UserID )
END
END

BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
BEGIN
IF @ReturnWhat = 5
BEGIN
SELECT
*
FROM dbo.LatestNonEditRDTheme
WHERE RDThemeMasterID = @EntityMasterid AND
StatusID = 81 AND
RDThemeMasterID IN (
SELECT
EntityID
FROM
vUserCanViewFinal
WHERE
userID = @UserID )
END
END
END
END
END
END
END
END
END
END
END
END
END


The two code chunks are identical, the top chunk is formatted as I'd like , the second is not. Any ideas as to how to correct this?

Thanks
Richard

p.s. I can't get the indenting in the code snippet to display when posting here, sorry.
MrT
0

Comments

1 comment

Sort by
  • Anu D
    Thanks for your post.

    I tried to replicate the issue with the query you have posted here.

    Can you kindly email your query with the actual indentation at support@red-gate.com ?
    Anu D
    0

Add comment

Please sign in to leave a comment.