Hi,

Just wondered..

declare @j-2 statement is inside the if block.

in this scenario sql server have display the error message stating not declared. But how it is ignoring.

Please explain..