Viewing 4 posts - 1 through 4 (of 4 total)
June 8, 2018 at 4:44 am
davidandrews13 - Wednesday, May 30, 2018 7:37 AMi found this. never heard of it before, though.
Thank you 🙂 I will try...
May 30, 2018 at 7:59 am
May 30, 2018 at 7:59 am
Hello try this,
WITH DATERANGE AS
(
SELECT DT = DATEADD(DD, 0, T.STARTDT), ET=T.ENDDATE
FROM (SELECT
CASE WHEN DATENAME(DW, DATEADD(DAY, 0, GETDATE()))...
May 28, 2018 at 7:54 am
Viewing 4 posts - 1 through 4 (of 4 total)