SELECT @MSGOUT = @MSGOUT + '

<tr>

<td>' + ss.ServerName +'</td>

<td>' + ss.DBName +'</td>

<td>' + Occurrences +'</td>

</tr>

'

FROM /*DBINVENTORY ss --after removing this commented words...I got required output

INNER JOIN*/

(SELECT ServerName,DBname,

cast(COUNT(dbname) as varchar(5))AS Occurrences

FROM DBINVENTORY d

GROUP BY ServerName,DBName

HAVING ( COUNT(DBName) > 1 )

)sq ON ss.DBName=sq.DBName