... TOP 1
'' AS Name,
CONVERT(uniqueidentifier,'00000000-0000-0000-0000-000000000000') AS ItemID
FROM
ExecutionLogStorage
) AS d1
ORDER BY d1.Name ASC
Additional Modifications:
For ...
... e.TimeStart, e.TimeEnd) [Total Time]
,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank]
FROM
[ReportServer].[dbo].[ExecutionLogStorage] e
INNER JOIN
[ReportServer].[dbo].[Catalog] ...
...
Catalog.Name AS ReportName,
DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun,
DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun,
DATEPART(year, ExecutionLogStorage.TimeStart) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.