CREATE PROCEDURE [dbo].[REQ_HEADER_PROC_ALL] AS
BEGIN
DECLARE @id CURSOR;
declare @pkey int;
SET @id = CURSOR FOR SELECT id FROM REQ_HEADER
OPEN @id
FETCH NEXT FROM @id INTO @pkey
WHILE @@FETCH_STATUS = 0
BEGIN
exec REQ_HEADER_proc @pkey
FETCH NEXT FROM @id INTO @pkey
END;
CLOSE @id;
DEALLOCATE @id;
END
It would appear that the REQ_HEADER_proc only accepts one row at a time in a very RBAR fashion. The cursor isn't the problem here. The proc is. It will need to be rewritten to do whatever it does to a set of IDs rather than just one at a time. Replacing this with any other method other than rewriting the proc itself is a total waste of time and effort.
17 People are following this question.
