UFN_OLAP_GETDATAMARTLASTREFRESH_FROMDATASOURCE

create function dbo.UFN_OLAP_GETDATAMARTLASTREFRESH_FROMDATASOURCE(@OLAPDATASOURCEID uniqueidentifier)
returns datetime
with execute as caller
as begin

    declare @DATAMARTLASTREFRESH datetime;

    select top 1
        @DATAMARTLASTREFRESH = [ETLHISTORY].[DATAWINDOWCLOSE]
    from dbo.[ETLHISTORY]
    where ETLHistory.OLAPDATASOURCEID = @OLAPDATASOURCEID
    and [ETLHISTORY].[COMPLETED] = 1
    order by [ETLHISTORY].[DATAWINDOWCLOSE] desc;

    return @DATAMARTLASTREFRESH;

end