Quick/Simple $ - SQL Server 2000 Web Log Row Count Sequence
$30-100 USD
Completed
Posted almost 18 years ago
$30-100 USD
Paid on delivery
*** URGENT, need this project bid accepted and complete within 1 day! This is an easy and quick SQL script project for those who know what they are doing ***
Hi, looking for most efficient way to create and populate new table that orders and generates sequence numbers based on a group, plus adds next and previous sequence
Input is a simple table that stores web page records:
ID int,
UserSessionID int,
CreateDate datetime,
PageName char(50),
QueryURL char(200),
What I'd like is new table that has:
UserSessionID int,
CreateDate datetime,
PageName char(50),
QueryURL char(200),
PageNumber int, - Page number (1 - n) for the UserSessionID
NextPageName char(50) - Empty if this is last
NextQueryURL char(200) - Empty if this is last
UserSessionID represents all records for a users session
So, basically the above will allow for some easy traversal reporting, entry and exit pages, etc.
Thanks!
Hi, I have a strong knowledge about sql statements and ASP, I will glad to help you. If you have a minute, take a look to my profile at http://www.domoblanco.com.ar. Best regards, Fred
Hello
This is a very tricky thing.. Need a proper attention and understanding of web server behavior to handle this situation..
Please see PMB for details.