stored procedure invokation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

stored procedure invokation

Hi, I have a UDF that returns a table to my stored procedure and in that stored procedure I want to invoke another stored procedure for each row of the returned table. Is there a way to accomplish this without the use of cursors? Puco
Calling the UDF in the second stored procedure in place of first should do the trick. Ofcourse u’ll have to use join inside the second SP with the resultst of the first. Complex solution but I think worth a try… Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard