SQL Server - Ho to get missing sequence of a series

Asked By bhanupratap singh on 23-Jan-14 07:20 AM
I need to display sequence start from to the user like

Seq No is start from 100 to 500
if use has used the no from 101 to 200 then I need to tell user that "Your Sequence start from 201
How to achieve in sql server 2008 with stored procedure
Thanking you
Robbe Morris replied to bhanupratap singh on 23-Jan-14 09:04 AM
https://www.nullskull.com/a/352/sql-server-table-variables-and-cursorless-cursor.aspx