Get a list of dates between two dates using a function

by

this few lines are the simple answer for this question in sql server.

WITH mycte AS
(
  SELECT CAST('2011-01-01' AS DATETIME) DateValue
  UNION ALL
  SELECT  DateValue + 1
  FROM    mycte   
  WHERE   DateValue + 1 < '2021-12-31'
)

SELECT  DateValue
FROM    mycte
OPTION (MAXRECURSION 0)

More Related Contents:

  1. Get first day of week in SQL Server
  2. How do I exclude Weekend days in a SQL Server query?
  3. Get dates from a week number in T-SQL
  4. Date conversion and culture: Difference between DATE and DATETIME
  5. SQL Query to find the last day of the month
  6. How to: Create trigger for auto update modified date with SQL Server 2008
  7. How to get difference of days/months/years (datediff) between two dates?
  8. Comparing dates stored as varchar
  9. Alias name is same as column name [closed]
  10. LocalDB deployment on client PC
  11. Foreign Key to multiple tables
  12. How to get Time from DateTime format in SQL?
  13. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  14. Get size of all tables in database
  15. Fuzzy matching using T-SQL
  16. How to get first and last day of previous month (with timestamp) in SQL Server
  17. SQL Server – inner join when updating [duplicate]
  18. How do I use the CONCAT function in SQL Server 2008 R2?
  19. EXEC sp_executesql with multiple parameters
  20. Best data store for billions of rows
  21. newid() inside sql server function
  22. How can I use a single mssql connection pool across several routes in an Express 4 web application?
  23. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  24. SQL “between” not inclusive
  25. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  26. What are some ways of accessing Microsoft SQL Server from Linux?
  27. LPAD in SQL Server 2008
  28. How does SQL Server decide format for implicit datetime conversion?
  29. EAV over SQL Server
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment