Home Forums SQL Server 2005 SQL Server 2005 General Discussion Paging Problem SQL 2005 using row_number and order by RE: Paging Problem SQL 2005 using row_number and order by

  • May 13, 2009 at 1:37 pm

    #994041

    Create a view with out the order by. Then select from the view and order by the results. That should work.

    Raymond Laubert
    Exceptional DBA of 2009 Finalist
    MCT, MCDBA, MCITP:SQL 2005 Admin,
    MCSE, OCP:10g