spUpdateEmailList_StartRefresh

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Status	int	IN
@StatusReport	ntext	IN
@AcquiredStartDate	datetime	IN
@AcquiredRecordCount	int	IN

Definition

Copy




CREATE PROCEDURE dbo.spUpdateEmailList_StartRefresh
(
        @PKID int OUTPUT,
    @Status int,
    @StatusReport ntext,
    @AcquiredStartDate datetime,
    @AcquiredRecordCount int
)
AS

DECLARE @hResult int  
SET @hResult = 0

BEGIN TRANSACTION

IF (@PKID<=0) 
    BEGIN
        SET @hResult = -1
    END 
ELSE 
    BEGIN
        UPDATE [dbo].EmailList
        SET
            [AcquiredStatus]=@Status,
            [AcquiredMsg]=@StatusReport,
            [AcquiredStartDate]=@AcquiredStartDate,
            [AcquiredRecordCount]=@AcquiredRecordCount
        WHERE ID=@PKID
        IF (@@ERROR <> 0) SET @hResult = @@ERROR
END

COMMIT TRANSACTION
RETURN @hResult