Re: how to calculate rank in selected records in sql server 2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 26 Mar 2008 22:48:38 +0000 (UTC)
(shilpa.vastrad@xxxxxxxxx) writes:
how to calculate rank in selected records in sql server 2000
Since the suggestions you got for row_number were not feasible to
you, but I was never told why, I don't feel like spending more time
without knowing what you are looking for.
Could you please give a more detailed description of your problem.
Preferrably you should give us:
o CREATE TABLE statement(s) for your tables.
o INSERT statements with sample data.
o The desired results given the sample.
o A short descrition of why you want that result.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- how to calculate rank in selected records in sql server 2000
- From: shilpa . vastrad
- how to calculate rank in selected records in sql server 2000
- Prev by Date: Re: help with DDL trigger. Moved from other newsgroup.
- Next by Date: Re: SQL Server - synchronizing database changes across servers
- Previous by thread: how to calculate rank in selected records in sql server 2000
- Next by thread: UTF-8 Coding of MSSQL 2005 DB
- Index(es):
Relevant Pages
|
