SELECT 0 as data,' All ' as label UNION SELECT logID as data,Replace(logName,'_','.') AS label FROM logWatcherLogs ORDER BY label SELECT Replace(logName,'_','.') AS serieslabel,hitcount FROM logWatcherLogs SELECT DISTINCT application as serieslabel,SUM(hitCount) as hitcount FROM logWatcherApplication WHERE logid = GROUP BY application SELECT DISTINCT page as serieslabel,SUM(hitCount) as hitcount FROM logWatcherPage WHERE logid = GROUP BY page SELECT DISTINCT severity as serieslabel,SUM(hitCount) as hitcount FROM logWatcherSeverity WHERE logid = GROUP BY severity SELECT DISTINCT thread as serieslabel,SUM(hitCount) as hitcount FROM logWatcherThread WHERE logid = GROUP BY thread SELECT DISTINCT Year(ld.date) as serieslabel,SUM(hitcount) hitcount FROM logWatcherDate ld WHERE ld.logid = GROUP BY Year(ld.date) ORDER BY Year(ld.date) SELECT TOP 12 i.item,i.month serieslabel, CASE WHEN SUM(l.hitcount) IS NULL THEN 0 ELSE SUM(l.hitcount) END AS hitcount FROM itemCount i LEFT OUTER JOIN logWatcherDate l ON i.item = DATEPART(m,l.date) AND l.logid = GROUP BY i.item,i.month ORDER BY i.item SELECT TOP 31 i.item as logdate, i.item serieslabel, CASE WHEN SUM(l.hitcount) IS NULL THEN 0 ELSE SUM(l.hitcount) END hitcount FROM itemcount i LEFT OUTER JOIN logWatcherDate l on i.item = DATEPART(dd,l.date) AND l.logid = GROUP BY i.item ORDER BY logdate SELECT TOP 7 i.item,i.weekday serieslabel, CASE WHEN SUM(l.hitcount) IS NULL THEN 0 ELSE SUM(l.hitcount) END AS hitcount FROM itemCount i LEFT OUTER JOIN logWatcherDate l ON i.item = DATEPART(dw,l.date) AND l.logid = GROUP BY i.item,i.weekday ORDER BY i.item SELECT TOP 24 i.item-1 as loghour, CASE WHEN i.item-1 = 0 THEN '12:00 AM' WHEN i.item-1 < 12 THEN CAST(i.item-1 AS VARCHAR(2))+':00 AM' WHEN i.item-1 = 12 THEN '12:00 PM' ELSE CAST(i.item-13 AS VARCHAR(2))+':00 PM' END serieslabel, CASE WHEN SUM(l.hitcount) IS NULL THEN 0 ELSE SUM(l.hitcount) END hitcount FROM itemcount i LEFT OUTER JOIN logWatcherDate l on i.item-1 = DATEPART(hh,l.date) AND l.logid = GROUP BY CAST(i.item-1 as varchar(2))+':00',DATEPART(HH,L.DATE),I.ITEM ORDER BY loghour SELECT TOP 4 i.item as logdate, i.item serieslabel, CASE WHEN SUM(l.hitcount) IS NULL THEN 0 ELSE SUM(l.hitcount) END hitcount FROM itemcount i LEFT OUTER JOIN logWatcherDate l on i.item = DATEPART(q,l.date) AND l.logid = GROUP BY i.item ORDER BY logdate