UFN_REVENUEBATCHREGISTRANT_GETREGISTRATIONCOUNTFORCONSTITUENTID

            create function dbo.UFN_REVENUEBATCHREGISTRANT_GETREGISTRATIONCOUNTFORCONSTITUENTID
            (
                @EVENTID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @BATCHID uniqueidentifier
            )
            returns int
            with execute as caller
            as begin
                declare @COUNT int

                select 
                    @COUNT = count(REGISTRATIONS.ID) 
                from (
                    select
                        REGISTRANT.ID
                    from
                        dbo.REGISTRANT 
                    where 
                        EVENTID = @EVENTID 
                    and CONSTITUENTID = @CONSTITUENTID
                    union all
                    select 
                        BATCHREVENUEREGISTRANT.ID
                    from
                        dbo.BATCHREVENUEREGISTRANT
                    where 
                        EVENTID = @EVENTID 
                    and 
                        CONSTITUENTID = @CONSTITUENTID
                    and
                        BATCHID = @BATCHID
                ) REGISTRATIONS

                return @COUNT
            end