USP_DATAFORMTEMPLATE_ADD_RESEARCHGROUPASSIGNPROSPECTMANAGER_PRELOAD

          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RESEARCHGROUPASSIGNPROSPECTMANAGER_PRELOAD
          (
            @PROSPECTMANAGERFUNDRAISERID uniqueidentifier = null output,
            @OVERWRITEEXISTINGPROSPECTMANAGER bit = null output,
            @PREVIOUSMANAGERENDDATE date = null output,
            @NEWMANAGERSTARTDATE date = null output
          ) as
            set nocount on;

            set @OVERWRITEEXISTINGPROSPECTMANAGER = 0;

            set @NEWMANAGERSTARTDATE = getdate();
            set @PREVIOUSMANAGERENDDATE = dateadd(day, -1, @NEWMANAGERSTARTDATE);

            return 0;