SQL Server Performance

stored procedure invokation

Discussion in 'T-SQL Performance Tuning for Developers' started by puco, Jul 22, 2003.

  1. puco New Member

    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
  2. gaurav_bindlish New Member

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

Share This Page