Sedang Disiapkan

Quick/Simple $ - SQL Server 2000 Web Log Row Count Sequence

*** 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!

Kemahiran: ASP, Pemprosesan Data

Lihat lebih lanjut: count sequence numbers sql server, row counter sql server 2000 select, sql script count record sequence row, what is a web script, simple reporting, int i, hi web, sql row sequence number, page rowcount sql server 2000, sequence sql server 2000, sql server 2000 count, sql server 2000 row counts, sql script row sequence number, sql server 2000 quick table count, sql count row sequence, sql server 2000 row count, quick web, on sql, web create, web asp, sql, SQL Server Reporting, sql script , Sql reporting, sql project

Tentang Majikan:
( 7 ulasan ) Lake Park, United States

ID Projek: #64534

Dianugerahkan kepada:

IndoFreelancer

Please read my message in your PM, Thank You.

$35 USD dalam sehari
(6 Ulasan)
4.1

3 freelancers are bidding on average $33 for this job

fedestabile

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

$35 USD dalam sehari
(7 Ulasan)
4.0
solutions2006

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.

$30 USD dalam sehari
(1 Ulasan)
1.0