Execute stored procedureForEachRow

-- =============================================
-- Author:        elconomeno
-- Create date:
-- Description:   
-- =============================================
CREATE PROCEDURE [dbo].[ExeCuteStoredProcedureForEachRow]

AS
BEGIN
declare @ParameterOfStoredPRocedureToExecute1 varchar(255)
declare cur cursor
for select ColumnWithPArameterValue
from TblToReadFrom -- or from dbo.MyTableFunction()

open cur
fetch next from cur into @ParameterOfStoredPRocedureToExecute1
while @@fetch_status = 0
begin
exec [dbo].[StoredProcedureToExecute] @ParameterOfStoredPRocedureToExecute1
fetch next from cur into @ParameterOfStoredPRocedureToExecute1

end
END