I have a Rate column in one of my SQL Table where Data is stored. The data in the rate column , is coming thro an Stored proc. In that existing stored proc, I found the condition
BEGIN
IF @taxPrd < '07/01/2000' OR
@taxPrd >= '11/01/2001' AND @taxPrd < '04/01/2003'
BEGIN
I changed it to ...so as to make it true for ALL periods after sep-1/09
BEGIN
IF @taxPrd < '07/01/2000' OR
( @taxPrd >= '11/01/2001' AND @taxPrd < '04/01/2003' ) OR
@taxPrd >= '09/01/2009'
BEGIN
hence now the rate is valid for
all less than Jul2000 OR
all in between Nov2001 and Apr2003 OR
all more than Sep2009
is the placements of brackets correct?