USP_SMARTQUERYINSTANCE_CREATESTATICTABLE

        create procedure dbo.USP_SMARTQUERYINSTANCE_CREATESTATICTABLE
            @SMARTQUERYINSTANCEID uniqueidentifier
        with execute as owner
        as
        set nocount on;

        declare @TABLENAME as nvarchar(128);
        declare @TABLEID as integer;
        declare @SQL as nvarchar(300);
        set @TableName = dbo.UFN_SMARTQUERYINSTANCE_MAKEIDSETSTATICTABLENAME(@SMARTQUERYINSTANCEID);

        select @TABLEID = id from dbo.sysobjects where id = object_id(@TABLENAME) and OBJECTPROPERTY(id, 'IsUserTable') = 1;

        if @TABLEID > 0
            -- table already exists so just truncate it
            exec ('TRUNCATE table [' + @TABLENAME + ']');
        else
                -- create new static table
            begin
                exec ('create table [' + @TABLENAME + '] (
                        ID uniqueidentifier not null rowguidcol 
                            constraint [PK_' + @TABLENAME + '] primary key clustered on OUTPUTGROUP

                        ) on OUTPUTGROUP;')

                exec ('grant select,insert on [' + @TABLENAME + '] to BBAPPFXSERVICEROLE;')
            end 

        return 0;