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 |
|
konica
Starting Member
2 Posts |
 Posted - 2004-12-10 : 20:40:48
|
| We are inserting records into a table using sql query analzyer . The records in the table will be extracted to a csv file using a utility program and sent to another company. The problem we are having is that the records do not get inserted into the table in the correct sequence. The records are selected from tables in the correct order, and then logic is applied in the fetch loop and then written to the hold table. . There is a hardcoded header record that gets insereted at the beginning of the program, before the main select that will appear someplace in the table not as record 1 as you would think. There is also a trailer record hard coded at the end of the program that doesn't appear as the last record in the table. Does any have an answer as to why the records don't get inserted in the proper sequenceThanks |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
inserting records into table improper sequence