Transact SQL Dump

November 15, 2022

T-SQL is Microsoft’s implementation of SQL with a whole bunch of additional features and functions on top.
Start of month date - DATEADD(m, DATEDIFF(m, 0, @CurrentDate), 0)
Start of Year date - DATEADD(yy, DATEDIFF(yy, 0, @CurrentDate), 0)
CTE

1
2
3
4
5
;WITH cteName AS 
(Select ...),
cteName2 AS
(Select ...)
Select * from cteName2