WITH days AS (SELECT - 7 AS d
UNION ALL
SELECT d + 1 AS Expr1
FROM days AS days_2
WHERE (d < 7))
SELECT TOP (5) DATEADD(day, d, GETDATE()) AS date, DATENAME(weekday, DATEADD(day, d, GETDATE())) AS Days
FROM days AS days_1
WHERE (DATEPART(week, GETDATE()) = DATEPART(week, DATEADD(day, d, GETDATE())))
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.