Wrong 'Order By'

Does anyone know any bug relationed with memory paging and order by clause?

I try to explain:

I have the following code inside a SP:

create table #tempA (colA char(2), colB numeric(7), colC numeric(3))

create table #tempB (colA char(2), colB numeric(7), colC numeric(3))
)
insert into #tempA
(...)

(...)
insert into #tempB (colA,colB,colC)
select colA,colB,colC
from #tempA
order by
colB,colA,colC

select * from #tempB

While using the reserved memory for the SQL Server, the last 'select' works pretty well. After the memory swapping starts, the 'select' returns data in incorrect order.

Any Ideas?
Thank you for all support than you can give me.


:confused: