Search results for query: *

That produces a total of all Displayname00 items, not justthe ones specified.

I would like it to look more like this. (I did this maually as an example) Total Application 2336 Adobe Reader 7.0 2864 Microsoft Data Access Components KB870669 1723 Microsoft Office Outlook 2003 1882 Microsoft VGX Q833989 2830 Outlook Express Q837009 2235 Windows 2000 Hotfix - KB824146 887...

This is the result of the original query. Note how it is in alphabetical/numerical order. Total Application 2336 Adobe Reader 7.0 2864 Microsoft Data Access Components KB870669 1723 Microsoft Office Outlook 2003 1882 Microsoft VGX Q833989 2830 Outlook Express Q837009 2235 Windows 2000 Hotfix -...

That gives a cumulative total for all the machineid's. I need to know the total for each of the Displayname00 individually. What you suggested would work if I did something like this only for each of the displayname00's. I would then have around 32 individual queries. [code] SELECT...

I removed the TOP 100 PERCENT and ORDER BY DisplayName00 and still the same results. I am trying to group the results together so that I can report on the total number of machines that have the patch installed.

I would like the query to output exactly as it is written and not sort, but from what I can find, SQL requires a group by or order by. When I remove them, I get errors. How can I do this? SELECT TOP 100 PERCENT COUNT(MachineID) AS Total, DisplayName00 AS Application FROM...