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.


Beceriler: ASP, Veri İşleme

Daha fazlasını gör: 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

İşveren Hakkında:
( 7 değerlendirme ) Lake Park, United States

Proje NO: #64534



Please read my message in your PM, Thank You.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(6 Değerlendirme)

Bu iş için 3 freelancer ortalamada $33 teklif veriyor


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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)