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 |
ArielR
Starting Member
21 Posts |
Posted - 2007-08-02 : 10:38:32
|
I need to make a procedure that return free numbers from a secuential table. Could somebody help me?.for ex: 1, 2, 3, 4, 5, 7, 8, 9, 10Its mast be return 6. Thank |
|
pootle_flump
1064 Posts |
Posted - 2007-08-02 : 10:42:07
|
What's a secuential table? Are these numbers in rows or columns? The former - sounds like you have a first normal form problem. The latter is easy. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-02 : 10:56:42
|
http://www.nigelrivett.net/SQLTsql/FindGapsInSequence.html_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|