Posted by Jer on 02/01/07 13:28
On Jan 31, 4:44 pm, "Jer" <jerry.w.bl...@saic.com> wrote:
> 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
I now remember reading about this in one of my SQLServer books. But
as Plaman says, the Order By worked in SQLServer 2000.
Thanks Dan and Plamen for the reminder.
[Back to original message]
|