UFN_SALESORDER_GETDONATIONTOTAL

        create function dbo.UFN_SALESORDER_GETDONATIONTOTAL
        (
            @SALESORDERID uniqueidentifier
        )
        returns money
        as begin
            declare @DONATIONTOTAL money

            select 
                @DONATIONTOTAL = coalesce(
                    (select sum([SALESORDERITEM].[TOTAL]) 
                    from dbo.[SALESORDERITEM]
                    where 
                        [SALESORDERITEM].[SALESORDERID] = @SALESORDERID and 
                        [SALESORDERITEM].[TYPECODE] = 2
                    ), 0)

            return @DONATIONTOTAL;
        end