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

Question

how to find missing numbers in two columns using sql server ? Example Colmn1 Colmn2 1 20 22 30 35 40 41 60 From above solution the no 21 31323334 are missing from sequence....... Please help me to solve this query......!

Rahul Prajapat · Answer

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.Column1tq.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 BEGIN PRINT @oldval SET @oldval=@oldval+1 END SET @oldval=@Val2+1 END CLOSE crsr DEALLOCATE crsr result is