ORDER BY clause within a view does not work in SQL 2005

• hr_sn

  Ten Centuries

  Points: 1092

  More actions

  August 23, 2007 at 4:33 am

  #728844

  I'm not sure about the performance, but you can achieve order in view by using CTE

  create view vLogin

  as

  with cte as

  (

  select *

  ,rowid=row_number() over(order by loginid asc)

  from login.dbo.login

  )

  select*

  fromcte

  This is allowed and works very well!! You might want to define some specific columns rather than *.