UFN_OLAP_GETDATAMARTLASTREFRESH
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MARTKEY | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.UFN_OLAP_GETDATAMARTLASTREFRESH(@MARTKEY nvarchar(100))
returns datetime
with execute as caller
as begin
declare @DATAMARTLASTREFRESH datetime;
select
@DATAMARTLASTREFRESH = max([ETLHISTORY].[DATAWINDOWCLOSE])
from dbo.[ETLHISTORY]
inner join dbo.[OLAPDATASOURCE] on [ETLHISTORY].OLAPDATASOURCEID = [OLAPDATASOURCE].[ID]
where [OLAPDATASOURCE].[MARTKEY] = @MARTKEY
and [ETLHISTORY].[COMPLETED] = 1;
return @DATAMARTLASTREFRESH;
end