quote:

---

Originally posted by jezemine

select val, percentage from mytable order by percentage desc

??

---

elsasoft.org

---

declare @t table (
Seq int not null identity(1,1) primary key clustered,
val int not null )

declare @rank table ( 
Rank int primary key clustered,
val int not null )

-- Load values in order by val column to be ranked
insert into @t (val)
select top 100 percent val
from
(
select top 200
	-- Generate random test data values
	val=(abs(checksum(newid()))%14)+347
from
	master.dbo.sysobjects a
order by
	a.id
) b
order by
	val

-- Load into rank table
insert into @rank ( Rank,val )
select	top 100 percent
	Rank = min(Seq),
	val
from
	@t
group by
	val
order by
	min(Seq)

select * from @rank


Results:

(200 row(s) affected)


(14 row(s) affected)

Rank        val         
----------- ----------- 
1           347
12          348
26          349
39          350
50          351
65          352
81          353
103         354
120         355
136         356
153         357
161         358
175         359
190         360

(14 row(s) affected)