USP_PROSPECTASSIGNEDALERT_SEND

            CREATE procedure dbo.USP_PROSPECTASSIGNEDALERT_SEND (
                @PREVIOUSFUNDRAISERID uniqueidentifier,
                @PROSPECTID uniqueidentifier
            ) as begin

                declare @FUNDRAISERID uniqueidentifier;
                select @FUNDRAISERID = PROSPECTMANAGERFUNDRAISERID from dbo.PROSPECT where PROSPECT.ID = @PROSPECTID;

                declare @FUNDRAISERAPPUSERID uniqueidentifier;
                select @FUNDRAISERAPPUSERID = ID from dbo.APPUSER where CONSTITUENTID = @FUNDRAISERID;

                if (@PREVIOUSFUNDRAISERID is null) or (@FUNDRAISERID <> @PREVIOUSFUNDRAISERID)
                    exec dbo.USP_ALERTTYPE_SENDTOAPPUSER '82EE5E7D-DA7A-461F-B803-9C52FF38F7B1', @FUNDRAISERAPPUSERID, @PROSPECTID;

                return 0;
            end