Home Forums SQL Server 2008 SQL Server Newbies Best approach when using needing to use stored procedure to retrieve value for each row RE: Best approach when using needing to use stored procedure to retrieve value for each row

  • If the result set returned by the second procedure is more than a few rows, the performance impact is likely to be large, since you would be processing a row at a time loop.

    Depending on how complex the Price calculation is, you might be able to include that logic in the second stored procedure. Without seeing the actual code that is being executed, it is not really possible to say how hard that would be.