Joining select query results - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Joining select query results

Author

Topic

alexmarshuk
Starting Member

12 Posts

Posted - 2009-08-13 : 11:08:07

Ifor
Aged Yak Warrior

700 Posts

Posted - 2009-08-13 : 12:16:51

[code]SELECT R.directorate
,COUNT(CASE WHEN N.hostname LIKE '%facebook%' THEN 1 END) AS fb_connections
,SUM(CASE WHEN N.hostname LIKE '%facebook%' THEN N.xfer_bytes END) / 1024 AS fb_xfer_kb
,COUNT(CASE WHEN N.hostname LIKE '%twitter%' THEN 1 END) AS twit_connections
,SUM(CASE WHEN N.hostname LIKE '%twitter%' THEN N.xfer_bytes END) / 1024 AS twit_xfer_kb
,COUNT(CASE WHEN N.hostname LIKE '%myspace%' THEN 1 END) AS ms_connections
,SUM(CASE WHEN N.hostname LIKE '%myspace%' THEN N.xfer_bytes END) / 1024 AS ms_xfer_kb
,COUNT(CASE WHEN N.hostname LIKE '%youtube%' THEN 1 END) AS yt_connections
,SUM(CASE WHEN N.hostname LIKE '%youtube%' THEN N.xfer_bytes END) / 1024 AS yt_xfer_kb
,COUNT(CASE WHEN N.hostname LIKE '%bebo%' THEN 1 END) AS bebo_connections
,SUM(CASE WHEN N.hostname LIKE '%bebo%' THEN N.xfer_bytes END) / 1024 AS bebo_xfer_kb
FROM NewSurf N
JOIN reports_staff_directory R
ON N.samaccountname = R.samaccountname
GROUP BY R.directorate
[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources