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

• Next in forum: Re: Input string -> table -> output string?
• Prev in forum: Re: Input string -> table -> output string?
• Thread view: Re: Query to find a missing number

[Reply to this message]