USP_DATALIST_AUTOMATCHCONSTITUENTEVENTEXIST

create procedure dbo.USP_DATALIST_AUTOMATCHCONSTITUENTEVENTEXIST
(
  @EVENTID uniqueidentifier = null,
  @CONSTITUENTID uniqueidentifier = null)
as
    set nocount on;
      begin
        if exists(select ID from dbo.REGISTRANT where CONSTITUENTID = @CONSTITUENTID and REGISTRANT.EVENTID = @EVENTID) or exists(select ID from dbo.EVENTSPONSOR ES(nolock) where ES.CONSTITUENTID = @CONSTITUENTID and ES.EVENTID = @EVENTID) 
          select 1 as ISEXIST
        else
          select 0 as ISEXIST

            end