Saga... (8/27/2012)

---

Main objective is to find duplicate db's...... and out put is perfect..... which I am looking for....

Can you please help wi

Saga... (8/27/2012)

---

Main objective is to find duplicate db's...... and out put is perfect..... which I am looking for....

Can you please help wi

Saga... (8/27/2012)

---

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

Luis Cazares (8/27/2012)

---

You were joining your grouped results with the original table with duplicates. You can get an even simpler version of your code like this, no need of a subquery:

SELECT @MSGOUT = @MSGOUT + '
    <tr>
    <td>' + ServerName +'</td>
    <td>' + DBName +'</td>
    <td>' + cast(COUNT(dbname) as varchar(5)) +'</td>
    
    </tr>
    '
FROM DBINVENTORY
GROUP BY ServerName,DBName
HAVING ( COUNT(DBName) > 1 )

Sean Lange (8/27/2012)

---

So does this mean you solved your issue or not?