Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT employee_nbr, date_hire, term_date FROM lawson_temp
;WITH Tally AS (SELECT TOP 366 n = ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 FROM sys.columns) SELECT Mondays = AllDays FROM Tally CROSS APPLY (SELECT DATEADD(day, n, 2013)) x(AllDays) WHERE (DATEPART(Quarter, AllDays) = 1) AND (DATENAME(Weekday, AllDays) = 'Monday') AND (DATEPART(YEAR, AllDays) = 2013)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!