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? PucoCalling 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
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
]]>