Formatting inconsistency

MrT

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.

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 ?