T-SQL: Find gap ranges using ROW_NUMBER()

Here I will be demonstrating how you can find gaps with help of the T_SQL function ROW_NUMBER() which I described in the previous video. In the first part I will write a query that shows where each gap begins and ends. In the second query I will show you how you generate a list of missing values.


Please leave feedback if this was helpful. Thanks!