Adrian,

Your solution would be more elegant indeed, but it doesn't work.

Unfortunately, the TOP keyword accepts only a constant, not a variable.

Dinesh,

Indeed, I would not add an index to a Qty...

Here are two shorter queries that do the same thing as your queries:

select distinct (select count(distinct number) from nMaxMin s2 where

s2.number<=s1.number) as rank, number from nMaxMin s1 order by 1

select...

Here is one using only DAY(), MONTH() AND YEAR() functions:

SELECT * FROM MyTest WHERE

year(@today)=year(@lastday) and month(@today)<month(@lastday) and

( month(birthday)>month(@today) and month(birthday)<month(@lastday)

or month(birthday)=month(@today) and day(birthday)>=day(@today)

or month(birthday)=month(@lastday)...

quote:

---

Great article. One disadvantage to a clustered index that I hear a lot of people claim is disk space. How...

quote:

---

However, if you use the function:

[...]

And then the select:

select * from lef(123456,123456,'LUN')

It uses the same index as the first...