|
The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024
|
|
[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: OT another SQL question
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.
Home |
Main Index |
Thread Index
|
|