UFN_SELECTION_CONSTITUENT_PATRONS

            CREATE function dbo.UFN_SELECTION_CONSTITUENT_PATRONS()
            returns table
            as return
                select distinct
                    SALESORDER.CONSTITUENTID as [ID]
                from 
                    dbo.SALESORDERITEMTICKET 
                    left join dbo.SALESORDERITEM on SALESORDERITEMTICKET.ID = SALESORDERITEM.ID 
                    left join dbo.SALESORDER on SALESORDER.ID = SALESORDERITEM.SALESORDERID
                where
                    SALESORDER.STATUSCODE <> 0
                    and SALESORDER.CONSTITUENTID is not null;