Need help in improving performance of a stored proc which invokes multiple scalar functions on the resultset

SQLServerCentral » Latest topics

Need help in improving performance of a stored proc which invokes multiple scalar functions on the resultset

I have stored proc which fetches a lot of data and the performance is really bad.

The problem is that this SP extensively uses Scalar functions (which does a complex calculation using while loop).
The scalar function is called on the resultse

more info...