Row_number() In A View In Sql Server 2005

I have tried the following query in Microsoft SQL Server Management Studio: select ROW_NUMBER() OVER(ORDER BY ret_id, dep_id DESC) AS 'Row Number' from Round_Trip_View an

Solution 1:

The problem was the view wizard.
What I learned: never use the wizards when you can code! :)