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-15 : 08:26:18
|
| menon writes "OK, i would like to know how to make use of the stored procedures in sql server. So, let me define my problemI have a customer master file that has say 10 fields. Then, i have a customer master table with say 20 fields. So, i want to know how to create a stored procedures to map the values from the customer master file onto the corresponding fields in the customer master table. Also, i'll have to assign default values to the remaining fields which are present in the master table. I would be really grateful if i could get some help on this issue. Hope that i've been clear on my issue.Thanking you before hand,menon" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-15 : 10:00:54
|
BCP or bulk insert the file into a temp table and insert the data from that table into the master table.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Stored Procedures