RE: OT another SQL question

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

what flavour of SQL are u using - MS SQL?

> -----Original Message-----
> From: Dr John Tankard [mailto:john@xxxxxxx]
> Sent: 04 October 2002 14:09
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] OT another SQL question
> 
> 
> 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 
> ---------------------~-->
> Plan to Sell a Home?
> http://us.click.yahoo.com/J2SnNA/y.lEAA/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.