... AS 'Site',
wm.[WeekNumber] AS FacilityWeek,
CONVERT(CHAR(10), GETDATE(), 103) AS 'WeekStart',
CONVERT(CHAR(10), DATEADD(day, 6, GETDATE()), 103) AS 'WeekEnd',
SD.[SetId] AS 'Set'
FRO ...
... EventFinish,
CONVERT(VARCHAR(2), tt.[Status]) AS Status,
'Details and other information' AS Tooltip
FROM [SLOTDETAILS] sd
INNER JOIN [TIMETABLE] tt
ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] ...
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.