What are the challenges you face when working across database platforms? Take the survey
Options

Formatting inconsistency

MrTMrT Posts: 2
edited September 18, 2009 10:53AM in SQL Prompt Previous Versions
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.

Comments

Sign In or Register to comment.