USP_APPUSERADHOCQUERYFAVORITE_ADD

Adds an ad-hoc query instance to the user favorites folder

Parameters

Parameter	Parameter Type	Mode
@ADHOCQUERYID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPUSERADHOCQUERYFAVORITE_ADD
(
    @ADHOCQUERYID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as 
begin
  declare @GETDATE datetime;
  set @GETDATE = getdate();

  set nocount on;

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