I have a stored procedure that retrieves customer data from one table and calls 2 UDFs to perform a calculation on data obtained from joined tables for accounting data.
The calculation needs to be performed for every row based on matching criteria of previous records. The query returns very few rows (5 at the most).
So far, I am getting accurate results.
My question is, should I try to accomplish the same thing by calling a stored procedure instead of UDFs?
I am looking for the preferred method.
Any comments or suggestions would be appreciated.