spUpdateEmailProjectAppeal_StartDupSearch
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AppealID | int | IN | |
| @Status | tinyint | IN | |
| @StartDate | datetime | IN | |
| @DupSearchMsg | ntext | IN |
Definition
Copy
CREATE PROCEDURE dbo.spUpdateEmailProjectAppeal_StartDupSearch
@AppealID int,
@Status tinyint,
@StartDate datetime,
@DupSearchMsg ntext
as
UPDATE EmailProjectAppeal
SET DuplicateSearchStatus = @Status, DuplicateSearchStartDate = @StartDate,
DuplicateSearchMsg = @DupSearchMsg
WHERE [ID] = @AppealID