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 - 2007-01-24 : 08:19:19
|
| shruthi writes "Hi, Starting to ask my question with the hope that i'll be provided a very good solution. I tried to copy some 2 lakhs of data from a table into a temporary table. Here the problem is, while copying this much of data, the sequential order of data copied into the temporary table get changed. To say in other words, rows get shuffled. But i want to have the exact physical structure of the data from the source table without changing the order. How can i do? Please provide me the solution as soon as possible." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-24 : 08:22:24
|
| What is the purpose of retaining physical structure while copying to temp table? You can retrieve data in whatever order you want using ORDER BY.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Question Reg.Temp Table