Posted by Jer on 01/31/07 23:44
I am using Access 2003 as a front-end to a SQL Server 2005 database.
I make design changes using SQL Server Management Studio. I have a
table that includes a datetime column. I create a view and sort by
the datetime field. When I initially look at the result it is sorted
correctly. Then I save the view and re-open it and it is not sorted.
I've simplified the view so it only contains the date field and it
still does not sort. Here is the view:
SELECT TOP (100) PERCENT Period_Date
FROM dbo.Period_Summary
ORDER BY Period_Date DESC
The date seems to be a random order.
I don't have this problem in the SQL Server 2000 version of the
database.
Help please!
Thanks,
Jerry
Navigation:
[Reply to this message]
|