How to execute stored procedure with every row of temp table ?

See more:

SQL

transaction

stored-procedure

problem
how to execute stored procedure with every row of temp table ?

I need to execute storedprocedurename inputfilepath outputfilepath. this is data exist on database on table Importertemplate. i need to get stored procedure name after execute with two parameters inputfilepath and outputfilepath. i need to loop with every row get storedprocedurename and inputfilepath and outpupath and execute it.

so how to loop within it it and execute stored procedure with every row'
I can write it but within loop cannot do it.

What I have tried:

create Proc ImporterQueue_RunModified1
As
BEGIN
WITH CTE AS
(
    SELECT Row_Number() OVER (ORDER BY GetDate()) AS rownumber, 
           StoredProcedureName, 
           ImporterQueue.CreateBy, 
           ImporterQueueID,
           applicationid, 
           dbo.ImporterTemplate.ImporterTemplateID, 
           InputFilePath, 
           OutputFilePath, 
           StoredProcedureName [ImporterTemplate.StoredProcedureName],
           RN = ROW_NUMBER() OVER (PARTITION BY applicationid ORDER BY ImporterQueueID ASC)
    FROM dbo.ImporterQueue WITH (NOLOCK) 
    INNER JOIN dbo.ImporterTemplate WITH (NOLOCK)  ON dbo.ImporterQueue.ImporterTemplateID = dbo.ImporterTemplate.ImporterTemplateID
    INNER JOIN Privilages.Module ON dbo.ImporterTemplate.ModuleID = Privilages.Module.ModuleID
    WHERE dbo.ImporterQueue.IsDeleted = 0 
    AND dbo.ImporterQueue.OverAllStatusID = 1 
)
SELECT rownumber , 
       RN , 
       ImporterQueueID,
       CreateBy,
       StoredProcedureName,
       InputFilePath,
       OutputFilePath
 INTO #results   FROM    CTE
    WHERE   RN = 1;

IF (
       SELECT OverAllStatusID 
       FROM dbo.ImporterQueue 
       INNER JOIN #results ON ImporterQueue.ImporterQueueID = #results.ImporterQueueID) <> 1 -- Pending
RETURN;
//here i need to write 
EXEC storedprocedurename inputfilepath outputpath
END