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

As you can probably tell, I'm pretty new to this stuff so I didn't even know about the existence of table valued functions.

So can you help me with creating one that gets the ClaimItems Status, please as I'm unsure how to start.