... INTERVAL 3 DAY), '\%e-\%b-\%y') AS Thu,
DATE_FORMAT(DATE_ADD(calendar.StartDate, INTERVAL 4 DAY), '\%e-\%b-\%y') AS Fri,
WEEKOFYEAR(calendar.StartDate) AS CalendarWeek
FROM
joes_weekstructure calendar
WHERE
calendar.SetID=(
SELECT ...
... 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 ...
... to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions.
The current structure looks similar to this:
ID SetID WeekNumber ...
... JOIN
[EQUIPMENT] eq
ON
eq.EquipId=re.EquipId
WHERE
re.RoomId=@GivenRoom
AND
re.SetId=@setId
This seems to have problems because when there are no matching rows (so zero results), BIDS ...
... 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] ...
... '.', -1)*1) AS lastassetid
FROM `my_new_database`.my_prefix_assets
WHERE `name` LIKE 'com_content.article.%'
ORDER BY lastassetid DESC LIMIT 0,1);
SET @new_jos_assets_last_inc=(
...
... bookings for a week based on a given date and campus
-- ===============================================================================
DECLARE
@GivenDate datetime,
@GivenCampus varchar(100),
@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.