Find working days between two dates in SQL Server
Many a times it is required to find working days between two dates. We do know that DATEDIFF function can be used to find differences between two dates; however the working …
Read MoreTag: datediff
Function to get date from datetime in SQL Server
Hi, Many a times need arises to get only date part from Datetime datatype/column/value. This blogs lists functions to get date from datetime in SQL Server. — SQL Server 2008 onwards …
Read MoreSQL Server T-SQL | Calculate Number of Leaves – excluding weekends
Hi Friends, Yesterday I was answering some questions on TechNet Forum when I saw an interesting and genuine problem. The user wanted to calculate the number of leaves taken by an …
Read More