>>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?

I suggest 2 possibilities
1. A table-valued inline function.
2. Using views when appropriate.