USP_CONSTITUENT_BBNC_DELETE

CREATE procedure dbo.USP_CONSTITUENT_BBNC_DELETE
(
  @SOURCECONSTITUENTID uniqueidentifier,
  @TARGETCONSTITUENTID uniqueidentifier
)
as
begin
  declare @BBNCUSERID int;

  declare @SOURCEBBNCUSERID int;
  declare @TARGETBBNCUSERID int;
  select @SOURCEBBNCUSERID = BBNCUSERID from dbo.NETCOMMUNITYCLIENTUSER where CONSTITUENTID = @SOURCECONSTITUENTID;
  select @TARGETBBNCUSERID = BBNCUSERID from dbo.NETCOMMUNITYCLIENTUSER where CONSTITUENTID = @TARGETCONSTITUENTID;

  -- if ID1 < ID2 then ID1 is the older of the two ID's

  if @SOURCEBBNCUSERID < @TARGETBBNCUSERID
  begin
    set @BBNCUSERID = @SOURCEBBNCUSERID;
  end
  else
  begin
    set @BBNCUSERID = @TARGETBBNCUSERID;
  end

  update dbo.CLIENTUSERS set DELETED = 1 where ID = @BBNCUSERID;

end