Cursor With Stored Procedure

I have a stored procedure that basically recieves the where clause of a select statement and executes the new sql statement... ie:





CREATE PROCEDURE [dbo].[bsa_GetImportIDs]


(@FilterText varchar(1000))


AS





DECLARE @MySQL varchar(1000)





SET @MySQL = "SELECT Import_ID FROM tblImport WHERE " + @FilterText





EXEC (@MySQL)


GO





Now, in another stored procedure, I need to use the stored procedure above in a cursor so that I can execute an insert statement for each occurance of the Import_ID that appears in that dataset... ie:





CREATE PROCEDURE [dbo].[bsa_PutLargeCase]


AS





DECLARE @CaseID uniqueidentifier


SET @CaseID = NewID()


Declare @ImportID uniqueidentifier





Declare curClient Cursor FAST_FORWARD for


SELECT Import_ID FROM dbo.bsa_GetImportIDs (@FilterText) <---- this does not work!!!





Open curClient


FETCH NEXT FROM curClient INTO @ImportID


WHILE @@FETCH_STATUS = 0


BEGIN





EXEC dbo.bsa_PutCaseDetail @CaseID, @ImportID





FETCH NEXT FROM curClient INTO @ImportID


END





CLOSE curClient


DEALLOCATE curClient





GO





How can I utilize my first stored procedure in the cursor of the second? ... or


Are there any other approaches that may be a better solution to what I am trying to accomplish?





Thanks in advance for any input.