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 - 2004-12-13 : 08:22:46
|
| Max writes "My question is how would I take a table with a structure as follows (the numbers in parenthesis are the column values)TABLE 1:ORIGIN (ABL)ABL (1)AQE (2)ALX (1)AMR (1)etc.And create another table that is structured as such:TABLE 2To Terminal (Origin Column Values)From Terminal (Column Name from table1)Terminal Days (Column Values)These tables are for use in another sproc also I just want to create a permanent table to draw from with the other sproc. I am not sure as I haven't really worked with recordsets and parsing them out in a sproc before.Thank you in advance" |
|
|
|
|
|
Transfer of information from one table to another with a sproc