... 6, calendar.StartDate)) AS VARCHAR(4))) AS CalendarWeek
FROM
cmisuser.WEEKSTRUCTURE calendar
/* specific to our calendars
WHERE
calendar.SetID=(
SELECT TOP 1 acyear.SetID
FROM cmisuser.WEEKSTRUCTURE ...
... AS 'Booking Notes',
c.[Name] AS 'Contact',
c.[Company] AS 'Dept',
c.[Phone] AS 'Phone'
FROM [CMISdata].[cmisuser].[SLOTDETAILS] sd
INNER JOIN [CMISdata].[cmisuser].[TIMETABLE] tt
ON ...
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.