RE: OT another SQL question

["Ben McCormack" <ben.mccormack@xxxxxxx>]

Just guessing a way to do this

Create a table with the range of numbers that you wish to check against
called CheckID

And then do something like

Select Devices
Where DeviceID NOT in (select CheckID from CheckID_Table)

I hope that you get the idea

Regards

Ben

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




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.