USP_ADHOCQUERY_CREATESTATICTABLE

        create procedure dbo.USP_ADHOCQUERY_CREATESTATICTABLE
            @ADHOCQUERYID uniqueidentifier
        with execute as owner
        as
        set nocount on

        declare @TABLENAME nvarchar(128)
        declare @IDCOLUMNTYPENAME nvarchar(128)

        set @TABLENAME = dbo.UFN_ADHOCQUERY_MAKEIDSETSTATICTABLENAME(@ADHOCQUERYID)

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


        exec USP_IDSET_CREATESTATICTABLE @TABLENAME, @IDCOLUMNTYPENAME