USP_APPUSERKPIINSTANCEFAVORITE_ADD

create procedure dbo.[USP_APPUSERKPIINSTANCEFAVORITE_ADD]
(
    @KPIINSTANCEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as 
begin
  declare @GETDATE datetime;
  set @GETDATE = getdate();

  set nocount on;

  if not exists(select ID from dbo.[APPUSERKPIINSTANCEFAVORITE] where [KPIINSTANCEID] = @KPIINSTANCEID and [APPUSERID] = @CURRENTAPPUSERID)
    insert into dbo.[APPUSERKPIINSTANCEFAVORITE]
    (
      [ID],
      [APPUSERID],
      [KPIINSTANCEID],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED])
    values
    (
      newid(),
      @CURRENTAPPUSERID,
      @KPIINSTANCEID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @GETDATE,
      @GETDATE
    )
end;