CREATE VIEW    [dbo].[swcatcount]
AS
SELECT    hwuuid,    
    sum(CASE scname WHEN 'Application Development' THEN 1 ELSE 0 END) as    [Application Development],
    sum(CASE scname WHEN 'Database Software' THEN 1 ELSE 0 END) as [Database Software],
    sum(CASE scname WHEN 'Graphics and Presentation' THEN 1 ELSE 0 END) as [Graphics and Presentation],
    sum(CASE scname WHEN 'Internet and Information Servers' THEN 1 ELSE 0 END) as [Internet and Information Servers],
    sum(CASE scname WHEN 'Microsoft Office Software' THEN 1 ELSE 0 END) as [Microsoft Office Software],
    sum(CASE scname WHEN 'Multimedia Tools and Utilities' THEN 1 ELSE 0 END)    as [Multimedia Tools and Utilities],
    sum(CASE scname WHEN 'Web Development and Publishing' THEN 1 ELSE 0 END)    as [Web Development and Publishing]
FROM  swcatlist
Group By hwuuid
GO
GRANT SELECT ON  [dbo].[swcatcount] TO [aiadmin]
GRANT INSERT ON  [dbo].[swcatcount] TO [aiadmin]
GRANT DELETE ON  [dbo].[swcatcount] TO [aiadmin]
GRANT UPDATE ON  [dbo].[swcatcount] TO [aiadmin]
GRANT SELECT ON  [dbo].[swcatcount] TO [aipublic]
GO