USP_USAGEREPORT_UPDATESTARTDATE

Updates the STARTDATE value of the application usage report process.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_USAGEREPORT_UPDATESTARTDATE
                (
                    @ID uniqueidentifier, 
                    @STARTDATE datetime,
                    @CHANGEAGENTID uniqueidentifier
                )
                as
                    update 
                        dbo.USAGEREPORTPROCESS    
                    set
                        USAGEREPORTPROCESS.STARTDATE = @STARTDATE,
                        USAGEREPORTPROCESS.CHANGEDBYID = @CHANGEAGENTID,
                        USAGEREPORTPROCESS.DATECHANGED = getdate()
                    where
                        USAGEREPORTPROCESS.ID = @ID;