/PHP/Mysql between all months days even null

Mysql between all months days even null

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME

SET @StartDate ='2014-03-01' SET @EndDate = GETDATE()

;WITH Dates(Date) AS
(
    SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @StartDate)) AS Date
    UNION ALL
    SELECT DATEADD(day, 1, Date) AS Date
    FROM Dates
    WHERE Date <= @EndDate
)
SELECT d.Date, r.Value
FROM Dates d
LEFT JOIN Times r ON d.Date = r.Date

Source: codeproject.com

Similar codes

0 vote349 views1 answer
LDownload multiple files as a zip-file using php
PHP
1 vote284 views1 answer
Laravel request integer
PHP
2 votes338 views1 answer
Sql row count php pdo
PHP
1 vote340 views1 answer
Best code editors for php
PHP
21 votes366 views6 answers
Laravel route parameters
PHP
-1 vote318 views1 answer
Codeigniter get num_rows
PHP
0 vote316 views1 answer
Gerar aquivo csv php
PHP
21 votes320 views3 answers
Php remove element from array by value
PHP
6 votes310 views2 answers
When will betelgeuse explode
PHP
0 vote309 views1 answer
Laravel latest from relationship
PHP