Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

Solution #1: We count the number of days of a year using the functions GETDATE, DATEADD, DATEDIFF and 1 subquery.

We encourage all our customers running SQL Server 2016 to start planning for the end of support. We have migration resources, best practices, as well as a rich ecosystem of partners ready to help.