Sort date by Desc doesn't work in SQL Server 2005

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

I have an application access 2003 (adp) as front end and SQL server 2005 as
backend.

My application worked well with sql server 2000 as backend, I migrated to
sql server 2005 and I found the following error:

I have a view:

SELECT TOP (100) PERCENT dDate, Eqmt, EqmtDate, HrsMeterPrev
FROM dbo.B3_Eqmt
ORDER BY dDate DESC

If I open this view over management studio, the Date sort is correct (DESC).
If I open this view from access the sort is worng is asc and not desc.
I re-create a new view and the problem still existing

Any suggestions to fix this issue?

There are another erros after migrating sql server 2000 to sql server 2005?

Thanks a lot
Jose
 
Per the sql standard, ORDER BY statement are not part of a view and this
problem (?) has been corrected in SQL-Server 2005.

In your case, add the sorting on the ADP side or enclose your view in a
select statement with an order by or replace TOP (100) PERCENT with TOP
2000000000.
 
Thans Sylvan,

It works but is not frindly to add top 100000 or more.
In Sql Server 2000 I nver found this problem
 
Back
Top