My setup
Windows XP SP3
MS SQL Server Management Studio 2008
SQL Server 2008 R2
Regional Setting: London BST (British Summer Time)
Tuesday the 11th of October 2011 at 06:00am:
CONVERT(CHAR(19), ...
... 1, 0)) 'Smart',
SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other',
COUNT(t1.VisitorBrowser) 'Total'
FROM
(SELECT
a.DateTimeStamp Date,
CASE
WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE'
WHEN ...
... via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp).
Here is a page of some MySQL queries I can do based on just those ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.