USP_DATAFORMTEMPLATE_EDITLOAD_ADHOCQUERYHIERARCHY_2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | |
| @TSLONG | bigint | INOUT | |
| @ADHOCQUERYHIERARCHY | xml | INOUT | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SMARTQUERYAVAILABLE | bit | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADHOCQUERYHIERARCHY_2
(
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@ADHOCQUERYHIERARCHY xml = null output,
@CURRENTAPPUSERID uniqueidentifier = null,
@SMARTQUERYAVAILABLE bit = null output
)
as
set nocount on;
select
@TSLONG = (select max(TSLONG) from dbo.ADHOCQUERYFOLDER),
@SMARTQUERYAVAILABLE = dbo.UFN_SMARTQUERY_AVAILABLE(),
@DATALOADED = 1;
return 0;