>Frank,
>
>We also discussed it yesterday that using scalar functions will be bad for the performance.
>
>I suggest to re-think your whole approach and don't use the functions.
>

Yes, I thought you were just referring to one of the functions so I redid that as a stored procedure, but this morning I have decided to try without the stored procedure for getting the Claim status and just using SQL. If I get this to work, then I will revisit the scalar functions and see what I can do to replace them.

So can you suggest a better approach for me?