Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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)
|Server running out of memory - Something is consuming all the available memory||17||58|
|SQL Server 2012 r2 - Make Temp Table Query Faster||5||41|
|I'm looking to copy specific data from one SQL table to another, and need help with the query.||5||19|
|MSSQL Import .SQL files - Increase Import Speed||9||35|