UFN_SALESORDER_GETEVENTREGISTRATIONTOTAL

        create function dbo.UFN_SALESORDER_GETEVENTREGISTRATIONTOTAL
        (
            @SALESORDERID uniqueidentifier
        )
        returns money
        as begin
            declare @EVENTREGISTRATIONTOTAL money

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

            return @EVENTREGISTRATIONTOTAL;
        end