How can I generate a temporary table filled with dates in SQL Server 2000?

by

I needed something similar, but all DAYS instead of all MONTHS.

Using the code from MatBailie as a starting point, here’s the SQL for creating a permanent table with all dates from 2000-01-01 to 2099-12-31:

CREATE TABLE _Dates (
  d DATE,
  PRIMARY KEY (d)
)
DECLARE @dIncr DATE = '2000-01-01'
DECLARE @dEnd DATE = '2100-01-01'

WHILE ( @dIncr < @dEnd )
BEGIN
  INSERT INTO _Dates (d) VALUES( @dIncr )
  SELECT @dIncr = DATEADD(DAY, 1, @dIncr )
END

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Function vs. Stored Procedure in SQL Server
  3. How to Join to first row
  4. SQL Server – How to lock a table until a stored procedure finishes
  5. What is a stored procedure?
  6. How to assign an exec result to a sql variable?
  7. SQL Server SELECT into existing table
  8. Pivot using SQL Server 2000
  9. How to check if a stored procedure exists before creating it
  10. Dynamic Sorting within SQL Stored Procedures
  11. How can I determine the status of a job?
  12. Procedure or function !!! has too many arguments specified
  13. Stored procedure that exports data into csv files only exports to one file
  14. In SQL Server, what does “SET ANSI_NULLS ON” mean?
  15. Comma separated values in a database field
  16. Inserting rows into a table with one IDENTITY column only [duplicate]
  17. How to get Return Value of a Stored Procedure
  18. Eliminate and reduce overlapping date ranges
  19. Find last sunday
  20. How to create a specific SQL Server stored procedure? [closed]
  21. Should I use != or for not equal in T-SQL?
  22. How should I pass a table name into a stored proc?
  23. SELECT FOR UPDATE with SQL Server
  24. Easiest way to populate a temp table with dates between and including 2 date parameters
  25. How to group by month from Date field using sql
  26. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  27. How to find column names for all tables in all databases in SQL Server
  28. SQL Row_Number() function in Where Clause
  29. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  30. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT

Leave a Comment