yep...but not using top. you can use below logic
SELECT
FROM
(
SELECT ROW_NUMBER() ORDER (PARTITION BY yearfield ORDER BY yoursortfield) AS seq,*
FROM table
)t
WHERE seq<=10
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Using Top in select
Posted - 10/02/2012 : 17:01:54
