spAddUpdate_ConditionRecipientStatistics

Parameters

Parameter	Parameter Type	Mode
@PKID	varchar(900)	IN
@Statistics	ntext	IN
@Status	int	IN

Definition

Copy



            CREATE PROCEDURE spAddUpdate_ConditionRecipientStatistics
                -- Add the parameters for the stored procedure here
                @PKID varchar(900),
                @Statistics ntext,
                @Status int
            AS
            BEGIN
                IF NOT EXISTS (SELECT [ID] FROM ConditionRecipientStatistics WHERE [ID]=@PKID)
                INSERT INTO ConditionRecipientStatistics ([ID], [Statistics], [Status], [UpdateDate]) values (@PKID, @Statistics, @Status, getutcdate())
                ELSE
                UPDATE ConditionRecipientStatistics SET [Statistics]=@Statistics, [Status]=@Status, [UpdateDate]=getutcdate() where [ID]=@PKID    
            END