Greg,

What's the best way of making your code dynamic? I tried declaring a variable so that the query became:

declare @n int

set @n = 76

select top 1 salary from

(select top @n employeeId from employee

order by salary asc) a

order by salary desc

but SQL Server doesn't like it.

I can get it to work with SET ROWCOUNT @n but I'm not sure what impact this has?

Thanks

Jeremy