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 |
|
sqldoubt
Starting Member
17 Posts |
 Posted - 2010-07-08 : 13:09:14
|
| Hi I am quite new to sql.I need to write a stored proc which reads data from a flat file BatchId StepId Db name Delete Table update flag1005 9 stg staging_order Yes1008 11 dest order_work No1009 12 cont order YEsBy reading this data into a temp variable, the stored proc need to delete data from diff tables.If update flag is yes it will update the value control value in another table.How can I achieve this. Any input is appreciated........... |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-08 : 15:54:51
|
| which part are you having problems? importing data from flat file to sql table / variableordeleting rows from table or flat file? |
 |
|
|
|
|
|
Delete Records from diff DB table using flat file