Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-22 : 09:39:37
|
ravvi writes "hi I've a table that looks like thisidnum page seqnum timedate 1000 http://www.msn.com 1 10/15/011000 http://www.cnn.com 2 10/15/011000 http://www.msdn.com 3 10/15/01 1001 http://www.msn.com 7 10/15/011001 http://www.cnn.com 8 10/15/011002 http://www.abc.com 1 10/14/011002 http://www.nbc.com 2 10/14/01 I need to generate a daily user flow report. i.e., the most common path the user follow. like idnum 1000 and 1001 have common path on 10/15/01. so the path would be msn.com,cnn.com,msdn.comsince idnum 1002 was the only visitor the common path will be abc.com,nbc.com on 10/14/01.and so on....I am not sure whether this help but -- seqnum is the seq. no. they follow. if idnum 1000 returns on 10/16/01 his idnum will be same but his seq num will be 4.Thanks in advanceRavikarnam@hotmail.com" |
|
|
|
|
|
self join - pl. help