USP_BUSINESSPROCESS_CREATEOUTPUTTABLE

                CREATE procedure [dbo].[USP_BUSINESSPROCESS_CREATEOUTPUTTABLE]
                    @TABLENAME nvarchar(128),
                    @FIELDLIST nvarchar(max)
                with execute as owner
                as
                    set nocount on;

                    exec ('create table [' + @TABLENAME + '] (BUSINESSPROCESSOUTPUT_PKID int identity primary key, ' + @FIELDLIST + ') on outputgroup');    
                    exec ('grant select,update,insert,delete,references on [' + @TABLENAME + '] to BBAPPFXSERVICEROLE');
                    exec ('grant select,update,insert,delete,references on [' + @TABLENAME + '] to BBAPPFXREPORTROLE');

                    return 0;