Hi all, I have the following table: I need to all Sophos softwares are listed as one (Sophos Anti-Virus). Therefore Microsoft Visual C++ 2005 Redistributable also be listed as one. Wich the best query to obtain this result? thanks! Douglas Filipe http://douglasfilipe.wordpress.com

Douglas, Do you mean, you want to order them ( like Sophos softwares should appear close to each other) or you want a single row for Sophos, Microsoft.? Please provide some details Regards, Manoj *Happy to help http://fascinatingsql.wordpress.com/

Hi Manoj, This table contain software inventory of all servers in my network. I need one licensing report. Sophos anti-virus is composed for Sophos Remote Management System Sophos Anti-Virus, Sophos AutoUpdate but is necessary one licensing for three softwares. Like a Microsoft Visual C++ 2005 Redistributable have two registries for server CARPO, but I need one registry. Thanks!Douglas Filipe http://douglasfilipe.wordpress.com