Hi all,

I come across the following scenario:
We have a table which store weblog records, say the table is called 'Weblog' contains many columns and three of them are:

*Logdate
*Sessionid
*Cookieid

Sessionid is unique, and cookieid can be duplicated
For example:

logdate sessionid cookieid
2002/09/10 12345 78888
2002/09/10 23456 78888
2002/09/11 74729 78888
2002/09/11 32433 99999
2002/09/12 54533 33333

This table contains approx. 8 million rows, what I need to do here is to produce a report (run daily)