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 |
|
Listen
Starting Member
44 Posts |
 Posted - 2004-03-11 : 19:57:07
|
| Hi guys,I made a SP that updates the ledger per client. My question is, how will I update all clients' ledger without using cursor. Does "SELECT" statement work to load all clients and at the same time updating them?Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-11 : 21:14:15
|
| Another double post. Please don't do this guys. It's annoying and doesn't get questions answered any faster.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Listen
Starting Member
44 Posts |
Posted - 2004-03-11 : 21:33:06
|
| Sorry. Its just because I really need the answer right away. Sorry and thanks. |
|
|
|
|
|
|
UPDATE using STORPROC