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 |
|
compound
Starting Member
7 Posts |
 Posted - 2005-05-13 : 16:52:35
|
| Great Day!I'm trying to set a process in which I can update certain fields of one table by running a stored procedure on the daily basis. I tried to use DTS with Data Driven Query and 2 connections to the same server. But because 2 connections are made to the same server I get “Connection is busy with results for another command” error. For example I have table A with fields a1, a2 table B with fields b1 , b2 and b3. Stored Procedure spAB which based on the value of a1 and b1 and b2 gives me the vaule of a2I would like to run spAB for each record in table A on the daily basis. Thank you in advance!Compound |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-14 : 16:57:55
|
| Why use dts? Just execute the SP from a job.It also looks like it's just an update statement.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Table updating process