USP_TURBOPARSE_UPDATECHECKDATE

Parameters

Parameter Parameter Type Mode Description
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


            create procedure dbo.USP_TURBOPARSE_UPDATECHECKDATE (
                @CHANGEAGENTID uniqueidentifier = null
            ) as begin
                set nocount on;

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

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

        update dbo.WEALTHPOINTCONFIGURATION
        set TURBOPARSECHECKED = @CURRENTDATE,
                      CHANGEDBYID = @CHANGEAGENTID,
                      DATECHANGED = @CURRENTDATE;

                return 0;
            end;