Tag: SQL

SQL set date variables and put them in a where clause declare @DateFirst datetime = ‘20170815’, @DateFinal datetime = ‘20341214’ — AND (@DateFirst Is Null OR @DateFirst < DATEVALUE) — AND (@DateFinal Is Null OR @DateFinal < DATEVALUE) Read more