In this article, you’ll learn how to use SQL to group dates by range. This is a fairly common task that involves checking if a…
Published May 24, 2022
Tag: TSQL
Published April 12, 2022
SQL Query to Find Records for Specific Date, Ignoring Time
T-SQL queries can be written to retrieve records for specific dates, times, or dates and times. If a record was created between these two dates,…
Published October 1, 2020
Using COALESCE to avoid using sp_executeSql
Creating stored procedures for table searches is simple with where clause. The difficulty arises when we have to include null or optional parameters for the…
Published October 1, 2020
Format datetime & date in SQL Server 2005
Often we end up on older versions of SQL Server and we have to recall the old ways for doing things. Here is a handy…