USP_MODELINGANDPROPENSITY_ADDIFDOESNOTEXIST

create procedure dbo.USP_MODELINGANDPROPENSITY_ADDIFDOESNOTEXIST
(
    @CONSTITUENTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

  if not exists (select top 1 ID from dbo.MODELINGANDPROPENSITY where ID = @CONSTITUENTID)
    insert into dbo.MODELINGANDPROPENSITY(ID,ADDEDBYID,CHANGEDBYID, DATEADDED, DATECHANGED) values
    (@CONSTITUENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

end