Friday, February 14, 2014

EXEC Stored Procedure on a row without cursor

DECLARE @StudentID INT = -1
WHILE (= 1) 
BEGIN
 SELECT TOP 1 @StudentID = StudentId
 FROM Students
 WHERE StudentId > @StudentID
 ORDER BY StudentId
 IF @@ROWCOUNT = 0
  BREAK;
 EXEC dbo.ProcedureName @StudentId
END