UFN_PARTICIPANT_RECRUITMENT_COUNT

CREATE function dbo.UFN_PARTICIPANT_RECRUITMENT_COUNT
(
    @CONSTITUENTID uniqueidentifier,
    @EVENTID uniqueidentifier
)
returns int
with execute as caller
as begin
    return (select COUNT(*)     
            from FAFCOMMUNICATIONSLOG fl
            inner join FAFEVENTCOMMUNICATIONCHANNEL fc on fl.EMAILJOBID = fc.EMAILJOBID
            where fl.CLIENTUSERSID = dbo.UFN_CLIENTUSERID_GET_BY_CONSTITUENT(@CONSTITUENTID) 
            AND EVENTID = @EVENTID
            AND fc.TYPECODE = 0 --registration only

          )
end