USP_ADHOCQUERY_CREATEORUPDATEIDSET

Parameters

Parameter	Parameter Type	Mode
@ADHOCQUERYID	uniqueidentifier	IN
@SQLWITHCLAUSE	nvarchar(max)	IN
@SQL	nvarchar(max)	IN
@USEINQUERYDESIGNER	bit	IN
@STATIC	bit	IN
@NUMROWS	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@IDSETREGISTERID	uniqueidentifier	INOUT
@IDSETFUNCTIONNAME	nvarchar(128)	INOUT

Definition

Copy



create procedure [dbo].[USP_ADHOCQUERY_CREATEORUPDATEIDSET]
    @ADHOCQUERYID [uniqueidentifier],
    @SQLWITHCLAUSE [nvarchar](max),
    @SQL [nvarchar](max),
    @USEINQUERYDESIGNER [bit] = 0,
    @STATIC [bit] = 0,
    @NUMROWS [int] = null,
    @CHANGEAGENTID [uniqueidentifier] = null,
    @IDSETREGISTERID uniqueidentifier = null output,
    @IDSETFUNCTIONNAME nvarchar(128) = null output
with execute as caller
as
set nocount on


declare @STATICTABLE as nvarchar(128)
declare @IDCOLUMNTYPENAME as nvarchar(128)

set @IDSETFUNCTIONNAME = dbo.UFN_ADHOCQUERY_MAKEIDSETFUNCTIONNAME(@ADHOCQUERYID)

if @STATIC = 1
begin
    set @STATICTABLE = dbo.UFN_ADHOCQUERY_MAKEIDSETSTATICTABLENAME(@ADHOCQUERYID)
end


select @IDCOLUMNTYPENAME = QUERYVIEWCATALOG.PRIMARYKEYTYPENAME from dbo.QUERYVIEWCATALOG
    inner join dbo.ADHOCQUERY on QUERYVIEWCATALOG.ID = ADHOCQUERY.QUERYVIEWCATALOGID
    where ADHOCQUERY.ID = @ADHOCQUERYID

exec USP_IDSET_CREATEORUPDATE @IDSETFUNCTIONNAME,  @STATICTABLE, @STATIC, @IDCOLUMNTYPENAME,@SQLWITHCLAUSE, @SQL, @NUMROWS, @CHANGEAGENTID

-- update the IDSetRegister
exec USP_IDSETREGISTER_CREATEORUPDATEFORADHOCQUERY @ADHOCQUERYID, @USEINQUERYDESIGNER, @STATIC, @NUMROWS, @CHANGEAGENTID, @IDSETREGISTERID output