Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-10 : 09:15:58
|
| Chandrasekhar Sarma writes "I am using 2 Stored procedures to process the records and storing them in a common table (Ex.'X'). If I execute the command select * from X , the records are not coming in the order of 'Empno' even though we have given order by command in selection statement of cursor used int the stored procedures. And one more problem is Some of the records inserted by the 1st stored procedure are coming (shuffling) after the records inserted by the 2nd stored procedure. What is the reason for this?But if I create index on 'Empno' the records coming in the order.Without creating index one can't get the order?" |
|
|
|
|
|
Shuffling of Records