RE: OT another SQL question

["BUTLER, Tony, FM" <roaming@xxxxxxx>]

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
***********************************************************************


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.