problema con top y order by.

[Andres95]

Es raro, porque ese es el comportamiento que deberias obtener...
Anexo ejemplo..

Código:

if object_id('tempdb..#mytemp') is not null drop table #mytemp


create table #mytemp (iId  int primary key, dt_fecha datetime )

insert into #mytemp values(1, '20101231')
insert into #mytemp values(2, '20101229')
insert into #mytemp values(3, '20101228')
insert into #mytemp values(4, '20101227')
insert into #mytemp values(5, '20101226')
insert into #mytemp values(6, '20101225')
insert into #mytemp values(7, '20101224')
insert into #mytemp values(8, '20101223')
insert into #mytemp values(9, '20101222')
insert into #mytemp values(10, '20101221')
insert into #mytemp values(11, '20101220')
insert into #mytemp values(12, '20101219')
insert into #mytemp values(13, '20101218')
insert into #mytemp values(14, '20101217')
insert into #mytemp values(15, '20101216')
insert into #mytemp values(16, '20101215')
insert into #mytemp values(17, '20101214')
insert into #mytemp values(18, '20101213')
insert into #mytemp values(19, '20101212')
insert into #mytemp values(20, '20101211')
insert into #mytemp values(21, '20101210')
insert into #mytemp values(22, '20101209')

SELECT TOP 10 * FROM  #mytemp Order by dt_fecha

si quieres muestra tu code y estoy seguro que alguien te dara una alternativa de solucion..

Saludos!