USP_APPUSERADHOCQUERYFAVORITE_DELETE
Deletes an ad-hoc query instance from the user favorites folder
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADHOCQUERYID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_APPUSERADHOCQUERYFAVORITE_DELETE
(
@ADHOCQUERYID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
begin
set nocount on;
declare @ID uniqueidentifier;
select @ID = ID from dbo.APPUSERADHOCQUERYFAVORITE
where ADHOCQUERYID = @ADHOCQUERYID and APPUSERID = @CURRENTAPPUSERID;
exec dbo.USP_APPUSERADHOCQUERYFAVORITE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
return 0;
end