Re: Query to find a missing number

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
.

Relevant Pages

  • Re: Programmers unpaid overtime.
    ... "A polynomial is a mathematical expression involving ... And if terms are missing, or the exponents are out of sequence, the ... You all think I'm paranoid, ...
    (comp.programming)
  • Re: Numbered style bug in Word 2007?
    ... And for more on the SEQ field, ... Field codes: Seq (Sequence) field ... field follows a *built-in* Heading 1 paragraph. ... show/hide field codes, press Alt+F9. ...
    (microsoft.public.word.pagelayout)
  • Re: puzzle
    ... Determine the xor of the numbers 0...n, ... >) sequence. ... Determine the sum of the numbers 0...n, ... The difference of the two sums is the missing number. ...
    (comp.programming)
  • Re: Query to find amissing number
    ... Here I need to write a query to find out that number 7 is missing in the ... given sequence. ... giving you a quick way to determine if any gaps exist. ...
    (comp.databases.sybase)
  • RE: Resetting figure number i caption
    ... > figure numbering sequence to be reset. ... where the figure number is reset after that the level one heading has ... >>> that the sequence of figure numbers is reset. ...
    (microsoft.public.word.numbering)