SET @tableHTML =
 N'<style type="text/css">'+
 N'.h1 {font-family: Arial, verdana;font-size:16px;border:0px;background-color:white;} '+
 N'.h2 {font-family: Arial, verdana;font-size:12px;border:0px;background-color:white;} '+
 N'body {font-family: Arial, verdana;} '+
 N'table{font-size:8px; border-collapse:collapse;} '+
 N'td{background-color:#F1F1F1; border:1px solid black; padding:3px;} '+
 N'th{background-color:#99CCFF;}'+
 N'</style>'+
 N'<table border="0">'+
 N'<tr><td class="h1">Database Backup Status Report</td></tr>' +
 N'<tr><td class="h2">AS OF '+convert(varchar(50),getdate(),101) + ' '+convert(varchar(50),getdate(),108)+N'</td></tr>'+
 N'</table>'+
 N'<table border="1">' +
 N'<tr> <th>DBName</th>'+
 N'<th>Backup Type</th>' +
 N'<th>Backup File</th>'+
 N'<th>Backup Size(bytes)</th>'+
 N'<th>Age(Days)</th>' +
 N'<th>Started</th>' +
 N'<th>Finished</th>' +
 N'<th>Time(mins)</th>' +
 N'</tr>' +
 CAST ( ( SELECT "td/@align"='left' ,td = bks.DBName, '',
 "td/@align"='left' ,td = bks.BackupType, '',
 "td/@align"='left' ,td = bks.BackupFile, '',
 "td/@align"='right',td = bks.BackupSize, '',
 "td/@align"='right',td = case when bks.BackupType<>'---NONE---' then convert(varchar(4),dateDiff(d,BackupStartDate_dt,getdate())) else '' end, '',
 "td/@align"='left' ,td = bks.BackupStartDate, '',
 "td/@align"='left' ,td = bks.BackupEndDate, '',
 "td/@align"='right',td = bks.BackupDuration
 FROM @Tbl as BKS
 ORDER BY BKS.DBname,BKS.BackupStartDate_dt
 FOR XML PATH('tr'), TYPE 
 ) AS NVARCHAR(MAX) ) +
 N'</table>' ;