I gang

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!

Færdigheder: ASP, Databehandling

Se mere: 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

Om arbejdsgiveren:
( 7 bedømmelser ) Lake Park, United States

Projekt-ID: #64534

Tildelt til:

IndoFreelancer

Please read my message in your PM, Thank You.

$35 USD på 1 dag
(6 bedømmelser)
4.1

3 freelancere byder i gennemsnit $33 for dette 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 på 1 dag
(7 bedømmelser)
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 på 1 dag
(1 bedømmelse)
1.0