RE: wish to add rows having NULL values as placeholders for "missing" dates

One Orange Chip

Points: 26944

October 2, 2013 at 7:34 am

Try this

select * from _dates d

left outer join cannedbackupjobs dbj on d.d = CONVERT(VARCHAR(10), dbj.starttime, 120)

where d.d between (select min(starttime) from cannedbackupjobs) and (select max(starttime) from cannedbackupjobs);

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum