... WHERE WeekNumber=wm.[WeekNumber])) AS 'Date',
tt.[RoomId] AS 'Room',
tt.[StartTime] AS 'Start',
tt.[FinishTime] AS 'Finish',
sd.[Descrip] AS 'Event Type',
sd.[Notes] AS 'Booking Notes',
c.[Name] ...
... expression as the one we use to get the equipment information:
SELECT
DISTINCT
re.[RoomId]
,re.[SiteId]
,re.[EquipId]
,eq.[Description]
FROM
[ROOMEQUIPMENT] re
INNER ...
... First get the events from your database and then get the rooms:
), Events AS (
--Create some events to place on the calendar
SELECT
tt.[RoomId] Room,
tt.[StartTime] EventStart',
tt.[FinishTime] ...
... dateadd(d, tt.[WeekDay] - 1, @baseDate)) AS 'Day',
tt.[SiteId] AS 'Site',
tt.[StartTime] AS 'Start',
tt.[FinishTime] AS 'Finish',
tt.[RoomId] AS 'Room',
sd.[Descrip] AS 'Event Type',
sd.[Notes] ...
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.