SELECT CASE  LOWER(@TimeFrame)
       WHEN 'day'   THEN dateadd(day, datediff(day, 0, DocumentViewDate), 0)
       WHEN 'month' THEN dateadd(month, datediff(month, 0, DocumentViewDate), 0)
       WHEN 'year'  THEN YEAR(DocumentViewDate)
       ELSE              dateadd(day, datediff(day, 0, DocumentViewDate), 0)
       END,
       NumberOfRecords = COUNT(*)
FROM   dbo.by27_DocumentsViews
WHERE  DocumentId = @DocumentId
GROUP BY CASE  LOWER(@TimeFrame)
       WHEN 'day'   THEN dateadd(day, datediff(day, 0, DocumentViewDate), 0)
       WHEN 'month' THEN dateadd(month, datediff(month, 0, DocumentViewDate), 0)
       WHEN 'year'  THEN YEAR(DocumentViewDate)
       ELSE              dateadd(day, datediff(day, 0, DocumentViewDate), 0)
       END

quote:

---

For example, if I set the timeframe to day I will need the following info:

t Views
20/01/2007 100
21/01/2007 200
22/01/2007 300

But if I have timeframe set to month I will need:

t Views
Jan 2007 1000
Fev 2007 2000

I suppose my code delivers just something like:
Views
1000
2000

---