How about something like
SELECT sum(UNIQUE_VISITs) AS sys_sum,
to_char(unique_date,'MM') AS monthno,
to_char(unique_date,'MON') AS monthname
FROM unique_sessions
WHERE SITE = '#client#'
GROUP BY monthno, month
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
