USP_ADDSITETOCONSTITUENT

CREATE procedure dbo.USP_ADDSITETOCONSTITUENT
(
    @CONSTITUENTID   uniqueidentifier,
    @EVENTID         uniqueidentifier
)
as
begin
    -- do work

  DECLARE @SITEID          uniqueidentifier
  DECLARE @CHANGEAGENTID   uniqueidentifier
  DECLARE @CURRENTDATE     datetime

  Set @CURRENTDATE = getdate()

  EXEC dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  Select @SITEID = SiteID from EVENTEXTENSION Where EventID = @EVENTID

  -- add site when available

  if @SITEID is not null and Not Exists(Select ID from CONSTITUENTSITE Where ConstituentID = @CONSTITUENTID and SiteID = @SITEID)
    Begin
        Insert into CONSTITUENTSITE (ID, CONSTITUENTID, SITEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          Values(newid(), @CONSTITUENTID, @SITEID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
    End

end