How to execute a stored procedure multiple times
You may try to do it using CURSORS
DECLARE @param INTDECLARE curs CURSOR LOCAL FAST_FORWARD FOR SELECT parameter FROM table_name WHERE ...OPEN cursFETCH NEXT FROM curs INTO @paramWHILE @@FETCH_STATUS = 0 BEGIN EXEC sp_storeProc @param FETCH NEXT FROM curs INTO @paramENDCLOSE cursDEALLOCATE curs