UFN_KPIINSTANCEHISTORY_GETCLOSESTID

Gets the closest history ID of a KPI instance value for a given date.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@KPIINSTANCEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



      create function dbo.[UFN_KPIINSTANCEHISTORY_GETCLOSESTID]
      (
        @KPIINSTANCEID uniqueidentifier,
        @ASOFDATE datetime
      )
      returns uniqueidentifier
      as
      begin
        declare @RETURNVALUE uniqueidentifier;
        declare @LATESTTIME datetime;

        set @LATESTTIME = dbo.[UFN_DATE_GETLATESTTIME](@ASOFDATE);

        select top(1) @RETURNVALUE = [ID]
        from dbo.[KPIINSTANCEHISTORY]
        where [KPIINSTANCEID] = @KPIINSTANCEID
        and [ASOFDATE] <= @LATESTTIME
        order by [ASOFDATE] desc;

        return @RETURNVALUE;
      end;