... this page. You should check this page from time to time to ensure that you are happy with any changes. This policy is effective from [date].
What we collect
We may collect the following information:
name ...
... giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING:
-- Assuming [This_Date]="21/03/2012"
(DT_DATE)(This_Date)
-- Assuming [This_Date]="20120321" ...
... THEN t2.[Day]
ELSE NULL
END as 'Day',
CASE
WHEN t2.Day=t3.Day THEN t2.[Date]
ELSE NULL
END as 'Date',
CASE
WHEN t2.Day=t3.Day THEN t2.[Room]
ELSE NULL
END as 'Room',
CASE
WHEN ...
... for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule.
Problem
Consider the following query:
SELECT
rb.[GivenDate]
, rb.[DateStart]
...
... day of month
SET @EndDate = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
--Last day to display on calendar
SET @EndDate = DATEADD(DAY,6-DATEPART(WEEKDAY,@EndDate),@EndDate)
; WITH Dates([Date]) ...
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.