-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|