USP_MEMBERSHIPSTATUS_SETVALUE

Parameters

Parameter	Parameter Type	Mode
@MEMBERSHIPID	uniqueidentifier	IN
@NEWSTATUS	tinyint	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_MEMBERSHIPSTATUS_SETVALUE
(
    @MEMBERSHIPID uniqueidentifier,
    @NEWSTATUS tinyint,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output


    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate();

    update dbo.MEMBERSHIP
    set STATUSCODE = @NEWSTATUS,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @MEMBERSHIPID
end