UFN_PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION_ITEMCOUNT

create function dbo.UFN_PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION_ITEMCOUNT(
    @PROGRAMEVENTREGISTRATIONSECTIONID uniqueidentifier,
    @REGISTRATIONINFORMATIONID uniqueidentifier
) returns tinyint
with execute as caller
as begin
    declare @PROGRAMID uniqueidentifier
    declare @EVENTID uniqueidentifier
    select @PROGRAMID = PROGRAMID, @EVENTID = EVENTID from dbo.PROGRAMEVENTREGISTRATIONSECTION where ID = @PROGRAMEVENTREGISTRATIONSECTIONID 

    declare @COUNT tinyint 
    select @COUNT = COUNT(1) 
    from dbo.PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION as persri
    inner join dbo.PROGRAMEVENTREGISTRATIONSECTION as pers
        on persri.PROGRAMEVENTREGISTRATIONSECTIONID = pers.ID
        and ((pers.PROGRAMID = @PROGRAMID) or (pers.EVENTID = @EVENTID))
    where REGISTRATIONINFORMATIONID = @REGISTRATIONINFORMATIONID

    return @COUNT
end