> >DECLARE @Test TABLE (PersonId int /*or whatever*/, ID Int IDENTITY(1,1)) >INSERT INTO @Test (PersonId) VALUES (??) >INSERT INTO @Test (PersonId) VALUES (??) >INSERT INTO @Test (PersonId) VALUES (??) >INSERT INTO @Test (PersonId) VALUES (??) >INSERT INTO @Test (PersonId) VALUES (??) >INSERT INTO @Test (PersonId) VALUES (??) > >DECLARE @PersonId int -- or whatever >DECLARE @id_min int >DECLARE @id_max int >SET @id_min = 1 >SELECT @id_max = MIN(Id) FROM @Test > >WHILE @id_min <= @id_max > BEGIN > SELECT @PersonId = PersonId FROM @Test WHERE Id = @id_min > --- Test your SP here > SET @id_min = @id_min + 1 > END >