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 2:23 pm

    #994083

    Ray Laubert (5/13/2009)

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

    I've heard that views are not that great performance wise. and not a good candidate unless they will b e used by more than one cases.

    will there be any performance hit?

    Tahnks,

    Nish.