SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Adding Publisher

Select
    SOFT.ProductName0 as 'Browser Name',
    Soft.Publisher0,
    Count(SOFT.ProductName0) as 'Count'
FROM
    v_GS_INSTALLED_SOFTWARE_CATEGORIZED SOFT
WHERE
    SOFT.ProductName0 LIKE 'Mozilla Firefox%'
    OR SOFT.ProductName0 LIKE 'Safari'
    OR SOFT.ProductName0 LIKE '%Internet Explorer%'
    OR SOFT.ProductName0 LIKE '%Google Chrome%'
Group by
    SOFT.ProductName0,
    Soft.Publisher0

Published Mar 27 2009, 06:58 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems