0

I have a number sequence field in a table that has some gaps/skipped numbers in it. I need to identify the skipped numbers. The only solution I can think of is to use iterative/cursor based loops and I suspect that will be fairly slow. Is there a faster method?

Improve this question
2
  • 2
    See this and this Commented Apr 27, 2017 at 18:58
  • Thanks user75ponic! Commented Apr 27, 2017 at 19:08
Related questions
1234
SQL Update from One Table to Another Based on a ID Match
3327
How to add a column with a default value to an existing table in SQL Server?
2541
Finding and deleting duplicate values in a SQL table
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.