Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave Ballantyne Returning the Top X row for each group RE: Returning the Top X row for each group

  • December 9, 2010 at 5:33 am

    #1260502

    Tim Widdup (12/9/2010)

    Ok , so how could you achieve this in SQL Server 2000? Again, just need the top x from each group ordered by the ID field.

    Thanks

    You will have to loop or cursor through the data. A "quirky update" may be possible, cant remember if possible in 2000 , sorry.


    Clear Sky SQL
    My Blog[/url]