USP_SYSTEMROLE_COPYDATALISTPERMISSIONS

            CREATE procedure dbo.USP_SYSTEMROLE_COPYDATALISTPERMISSIONS
            (
                @NEWFEATUREID uniqueidentifier,
                @PERMISSIONEDFEATUREID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            --Used for revisions
            set nocount on;

            begin try

                declare @CURRENTDATE datetime;

                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                insert into dbo.SYSTEMROLEPERM_DATALIST
                (
                    SYSTEMROLEID, 
                    DATALISTCATALOGID, 
                    GRANTORDENY, 
                    ADDEDBYID, 
                    CHANGEDBYID, 
                    DATEADDED, 
                    DATECHANGED
                )
                select 
                    SYSTEMROLEID, 
                    @NEWFEATUREID, 
                    GRANTORDENY, 
                    @CHANGEAGENTID, 
                    @CHANGEAGENTID, 
                    @CURRENTDATE, 
                    @CURRENTDATE
                from dbo.SYSTEMROLEPERM_DATALIST
                where DATALISTCATALOGID = @PERMISSIONEDFEATUREID
                        and not exists(select top 1 SUB.ID from dbo.SYSTEMROLEPERM_DATALIST SUB
                                    where SUB.DATALISTCATALOGID = @NEWFEATUREID and SUB.SYSTEMROLEID = SYSTEMROLEPERM_DATALIST.SYSTEMROLEID)
                        and exists(select top 1 CAT.ID from DATALISTCATALOG CAT where CAT.ID = @NEWFEATUREID);

            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
            end catch