USP_DATALIST_FAFEVENTSPONSORBYCLIENTID

create procedure dbo.USP_DATALIST_FAFEVENTSPONSORBYCLIENTID(
  @CLIENTUSERSID integer,
  @EVENTID uniqueidentifier
)
as
    set nocount on;

DECLARE @CONSTITUENTID uniqueidentifier
SET @CONSTITUENTID = dbo.UFN_CONSTITUENT_GET_BY_CLIENTUSERID(@CLIENTUSERSID)

    select 
    ID,
    ALLOWADMINACCESSHQ
    from dbo.EVENTSPONSOR
    where CONSTITUENTID = @CONSTITUENTID
    AND EVENTID = @EVENTID