fill in row (date) when chronological date is missing in result

select top 1000  
case when isdate(backup_start_date) = 1 then CONVERT(VARCHAR(10), backup_start_date, 120) else '0' end Date,  
count(*) VERIFYNumberOfLogBackupsPerDay
from msdb..backupset where database_name = 'cognox_bk' and type ='L'
group by case when isdate(backup_start_date) = 1 then CONVERT(VARCHAR(10), backup_start_date, 120) else '0' end
order by 1 desc 

Select allOpen in new window