Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-25 : 08:49:10
|
| Tom writes "I have a table containing a CD inventory. One of the fields is a SlotID, which corresponds to a slot in our 300-disc changer. I'm attempting to write a SQL statement that will return all of the empty slots in the changer -- that is, all numbers between 1 and 300 that don't exist in the CD tables SlotID field. Please help. I haven't found anyone else who is able to answer this question!Thanks!Tom" |
|
|
|
|
|
Finding Records Not Existing In Numerical Range