USP_UPDATE_SOLICITCODEID_BY_USERID

create procedure dbo.USP_UPDATE_SOLICITCODEID_BY_USERID
(
@UserId Int,
@SOLICITCODEID uniqueidentifier
)
as
BEGIN
if not exists(select top 1 1 from [dbo].[CONSTITUENTSOLICITCODE] CSC  
              inner join [dbo].[SOLICITCODE] SC  on CSC.SOLICITCODEID = SC.ID  
              inner join NETCOMMUNITYCLIENTUSER as NCU on NCU.CONSTITUENTID = CSC.CONSTITUENTID and NCU.BBNCUSERID = @UserID
              where ENDDATE is null  and SC.ID = @SOLICITCODEID)
  BEGIN
      declare @CHANGEAGENTID uniqueidentifier;
      declare @CONSTITUENTID uniqueidentifier;
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
      select @CONSTITUENTID = CONSTITUENTID from NETCOMMUNITYCLIENTUSER where BBNCUSERID = @UserID
      IF @CONSTITUENTID IS NOT NULL  
      BEGIN
            declare @STARTDATE datetime = getdate();
      exec dbo.USP_CONSTITUENTSOLICITCODE_ADD null, @SOLICITCODEID, @CONSTITUENTID, @STARTDATE, null, '', @CHANGEAGENTID;
      END 
  END 
END