UFN_PROGRAMMING_GETTOTALADMISSIONTICKETSSOLD

        CREATE function dbo.UFN_PROGRAMMING_GETTOTALADMISSIONTICKETSSOLD()
        returns integer
        with execute as caller
        as begin
            return (
                select sum(SOI.QUANTITY) - coalesce(sum(CI.QUANTITY),0)
                from dbo.SALESORDERITEM SOI
                left outer join dbo.CREDITITEM CI on CI.SALESORDERITEMID = SOI.ID
                inner join dbo.SALESORDERITEMTICKET SOIT on SOI.ID = SOIT.ID
                inner join dbo.PROGRAM P on SOIT.PROGRAMID = P.ID
                inner join dbo.SALESORDER SO on SO.ID = SOI.SALESORDERID
                where P.ISDAILYADMISSION = 1
                and SO.STATUSCODE in (1,3,4)
                and exists(select 1 from dbo.TICKET where SALESORDERITEMTICKETID = SOIT.ID and STATUSCODE <> 2)
            )
        end