USP_SYSTEMROLE_COPYTASKPERMISSIONS

            create procedure dbo.USP_SYSTEMROLE_COPYTASKPERMISSIONS
            (
                @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.SYSTEMROLETASK
                (
                    SYSTEMROLEID, 
                    TASKID, 
                    DISPLAYONHOMEPAGE, 
                    ADDEDBYID, 
                    CHANGEDBYID, 
                    DATEADDED, 
                    DATECHANGED
                )
                select 
                    SYSTEMROLEID, 
                    @NEWFEATUREID, 
                    DISPLAYONHOMEPAGE, 
                    @CHANGEAGENTID, 
                    @CHANGEAGENTID, 
                    @CURRENTDATE, 
                    @CURRENTDATE
                from dbo.SYSTEMROLETASK
                where TASKID = @PERMISSIONEDFEATUREID
                        and not exists(select top 1 SUB.ID from dbo.SYSTEMROLETASK SUB
                                    where SUB.TASKID = @NEWFEATUREID and SUB.SYSTEMROLEID = SYSTEMROLETASK.SYSTEMROLEID)
                        and exists(select top 1 CAT.ID from TASKCATALOG CAT where CAT.ID = @NEWFEATUREID);


            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
            end catch