Viewing 2 posts - 1 through 2 (of 2 total)
Please post sample imputs and expected outputs. That would help us to better understand the problem.
November 3, 2009 at 11:14 pm
#1074683
Add ISNULL to your select statement and set the value to 0 or 1 as required in your select statement.
Here is the solution.
DECLARE @SequenceNo int
SET @SequenceNo = 0
SELECT @SequenceNo...
October 28, 2009 at 11:55 pm
#1072243