This should get you going:
Declare @HoldIds int
Select @HoldIds = MIN(userid)
from users
WHILE (@HoldIds <= select max(userid) from users)
begin
Select * From items where userid =@HoldIds
Select TOP 1 @HoldIds = userid
FROM users
WHERE userid >= @HoldIds
ORDER BY userid
END
The key is that @HoldIds can only hold one value at a time, so you must loop through the table.
Tara Kizer
aka tduggan
looping over a select statment
Forum Locked
Posted - 03/02/2006 : 14:07:29
