n+1 problems in stored procedures

It is probably best to NOT call a function making a select statement for each record returned from a select statement in a sproc. Try to instead query the other data in one select to a temp table and join the table onto the select that otherwise needed to reach out to the function.