Create a temporary table

insert into <tmp table>

exec sp_abc

After the insert create proper indexes ans then use it in your sql satement

P/S: Most compound sql statements can have multiples instruction...

Insert your records in a temporary table using an autoincrement column as the key (let say "lineno"). After doing so, your @@rowcount variable will be affected and you will be...