-
Personal Links
Verified Services
Top 30 PowerShell bloggers of 2018
https://www.sqlshack.com/top-50-powershell-bloggers-of-2018/#Prashanth%20JayaramMy Blog is ranked amongst the Top 50 SQL blogs worldwide
http://blog.feedspot.com/sql_blogs/DZone MVB
Microsoft
Tag Archives: calendar dates
T-SQL to Display Weekends Between two Dates
Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered in the below SQL Download T-SQLΒ WeekendBetweenTwoValidDates DECLARE @beginDate Date=’20150101′, @endDate Date=’20150131′ DECLARE @Calendar Table (CalendarDate Date Primary key, IsWeekend Bit) … Continue reading
Posted in T-SQL
Tagged calendar dates, Calendar Example, choose, choose example, DATEPART, Display Weekend, find weekends, T-sQL calendar dates, Table dataType
2 Comments
Prashanth Jayaram 