RE: OT another SQL question

["Dr John Tankard" <john@xxxxxxx>]

Its big 1...999999.

The only way I could think to do it was to create a table that's auto
inc, insert 1000000 records and do a not in to a select DeviceID in
Devices

John

> -----Original Message-----
> From: BUTLER, Tony, FM [mailto:roaming@xxxxxxx] 
> Sent: 04 October 2002 13:56
> To: 'ukha_d@xxxxxxx'
> Subject: RE: [ukha_d] OT another SQL question
> 
> 
> John, 
> 
> What is the range of the numbers?
> Do you really want it to list all missing from 1000 to 9999?
> 
> T.
> 
> > -----Original Message-----
> > From: Dr John Tankard [mailto:john@xxxxxxx]
> > Sent: 04 October 2002 13:52
> > To: ukha_d@xxxxxxx
> > Subject: [ukha_d] OT another SQL question
> > 
> > 
> > Sorry for the OT post
> > 
> > Is it possible in SQL to do this :-
> > 
> > I have a table:-
> > 
> > Devices
> > --------
> > DeviceID
> > ..
> > 
> > 
> > And in the table there are some missing device numbers ie
> > 
> > 1000
> > 1001
> > 1003
> > 1004
> > 
> > In SQL is it possible to list missing numbers ie 1002 ?
> > 
> > John
> > 
> > 
> > 
> > ------------------------ Yahoo! Groups Sponsor
> > ---------------------~-->
> > Home Selling? Try Us!
> > http://us.click.yahoo.com/QrPZMC/iTmEAA/MVfIAA/IBOolB/TM
> >
--------------------------------------------------------------
> > -------~->
> > 
> > http://www.automatedhome.co.uk
> > Post message: ukha_d@xxxxxxx 
> > Subscribe:  ukha_d-subscribe@xxxxxxx 
> > Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
> > List owner:  ukha_d-owner@xxxxxxx
> > 
> > List of UKHA Groups here -
> > http://groups.yahoo.com/group/UKHA_Grouplists/
> > 
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > 
> > 
> 
> 
> **************************************************************
> *********
>       Visit our Internet site at http://www.rbsmarkets.com
> 
> This e-mail is intended only for the addressee named above.
> As this e-mail may contain confidential or privileged 
> information, if you are not the named addressee, you are not 
> authorised to retain, read, copy or disseminate this message 
> or any part of it. The Royal Bank of Scotland is registered 
> in Scotland No 90312 Registered Office: 36 St Andrew Square, 
> Edinburgh EH2 2YB 
> Regulated by the Financial Services Authority
> **************************************************************
> *********
> 
> ------------------------ Yahoo! Groups Sponsor 
> ---------------------~--> Sell a Home for Top $ 
http://us.click.yahoo.com/RrPZMC/jTmEAA/MVfIAA/IBOolB/TM
---------------------------------------------------------------------~->

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor

ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.