Posted by Hugo Kornelis on 07/13/06 21:28

On Thu, 13 Jul 2006 21:43:21 +0530, Mahesh BS wrote:

>
>
>Hello,
>
>
>
> I need to write a query to find out a set of missing number in a given
>sequence.

Hi Mahesh,

Check out http://www.aspfaq.com/show.asp?id=2516, under the heading
"Finding IDENTITY gaps".

--
Hugo Kornelis, SQL Server MVP

[Back to original message]