David McAfee
davidmcafee at gmail.com
Fri Jan 21 13:59:51 CST 2011
Is there a better way to do this?
IF (@ChangeKey IN(0,1,2,3,4,5,8,9,10,11,12,13))
BEGIN
--Do a bunch of stuff here
END
ELSE IF (@ChangeKey IN(6,7,14,15) AND @NewStart >@OldEnd)
BEGIN
--Do a bunch of stuff here
END
ELSE IF (@ChangeKey IN(6,7,14,15) AND @NewEnd <@OldStart)
BEGIN
--Do a bunch of stuff here
END
ELSE IF (@ChangeKey IN(6,7,14,15) AND @NewStart <@OldStart AND @NewEnd
>@OldEnd)
BEGIN
--Do a bunch of stuff here
END