Listing 4: Example Global Procedure Call

CREATE Procedure Global_TransferDelta AS

--Execute every stored procedure beginning with "sp_TransferDelta" 
DECLARE @SPName varchar(100) 
DECLARE GetSPName CURSOR FORWARD_ONLY FOR 
SELECT Name FROM Sysobjects WHERE Type = 'P' AND Name LIKE 'sp_TransferDelta%' ORDER BY 1
OPEN GetSPName 
FETCH NEXT FROM GetSPName into @SPName 
WHILE @@FETCH_STATUS <> -1 
	BEGIN 
		EXEC @SPName 
		FETCH NEXT FROM GetSPName into @SPName 
	END 
CLOSE GetSPName 
DEALLOCATE GetSPName 
RETURN