USP_APPUSERKPIINSTANCEFAVORITE_DELETE

create procedure dbo.[USP_APPUSERKPIINSTANCEFAVORITE_DELETE]
(
    @KPIINSTANCEID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
begin
    set nocount on; 

    declare @ID uniqueidentifier;

    select 
    @ID = ID 
  from dbo.[APPUSERKPIINSTANCEFAVORITE]
    where [KPIINSTANCEID] = @KPIINSTANCEID and [APPUSERID] = @CURRENTAPPUSERID;

    exec dbo.[USP_APPUSERKPIINSTANCEFAVORITE_DELETEBYID_WITHCHANGEAGENTID] @ID, @CHANGEAGENTID;

    return 0;
end