UFN_RESERVATION_GETRESOURCETOTAL

            CREATE function dbo.UFN_RESERVATION_GETRESOURCETOTAL(@ID uniqueidentifier)
            returns money
            with execute as caller
            as begin
                return coalesce(
                    (select sum(TOTAL)
                    from dbo.SALESORDERITEM
                    where SALESORDERITEM.SALESORDERID = @ID
                        and SALESORDERITEM.TYPECODE in (8,9)
                ),0);
            end