UFN_SALESORDER_GETTICKETCOMBINATIONPRICE

CREATE function dbo.UFN_SALESORDER_GETTICKETCOMBINATIONPRICE(@SALESORDERITEMID uniqueidentifier)
returns money
with execute as caller
as begin

declare @TICKETCOMBINATIONID uniqueidentifier;
declare @PRICETYPECODEID uniqueidentifier;

select
    @TICKETCOMBINATIONID = C.TICKETCOMBINATIONID,
    @PRICETYPECODEID = T.PRICETYPECODEID
from dbo.SALESORDERITEMTICKETCOMBINATION C
inner join dbo.SALESORDERITEMTICKET T on C.ID = T.ID
where T.ID = @SALESORDERITEMID;

return (
    select sum(I.PRICE)
    from dbo.SALESORDERITEMTICKETCOMBINATION C
    inner join dbo.SALESORDERITEMTICKET T on C.ID = T.ID
    inner join dbo.SALESORDERITEM I on T.ID = I.ID
    where T.PRICETYPECODEID = @PRICETYPECODEID
        and C.TICKETCOMBINATIONID = @TICKETCOMBINATIONID
);

end