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