how to find missing numbers in two columns using sql server?

hello @ajit You can use cursor to find the missing number in two column.

 Try this.

 

 

 DECLARE @Val1 int,@Val2 [int],@oldval [int]
DECLARE crsr CURSOR
LOCAL SCROLL STATIC
FOR
SELECT tq.Column1,tq.Column2 from dbo.tblQuery tq
OPEN crsr
FETCH NEXT FROM crsr
INTO @Val1,@Val2
SET @oldval =@Val2+1
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM crsr
INTO @Val1,@Val2
WHILE @oldval<@Val1
BEGIN
PRINT @oldval
SET @oldval=@oldval+1
END
SET @oldval=@Val2+1
END
CLOSE crsr
DEALLOCATE crsr

 

result is