Tag / MS SQL

To add or subtract some date/time you can use MS SQL function: DATEADD(datepart, number, date) Let's say you need to add five months to current date, use this: SELECT * FROM YourTable…

Sometimes we need to select values grouped by month from MS SQL Table. Probably the easiest way to do it is to call function DateAdd with DateDiff: SELECT Sum(YourColumn), DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0)…