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 - 2001-01-30 : 13:24:06
|
Joe writes "Hi, I'm self-learning SQL and I'm new to it. I am trying to develop a recursive Stored proc. to update quantities for a device. Each device can me made up of a number of other devices (excluding itself).
When the device qty is updated, I want to find all parts and their parts and their parts (etc. no limit) and update their quantities too.
I can do this quite easily in code, and while I was using a desktop database.
Would I use cursors in T-SQL ? I'm a little stuck.
Thanks for any help.
Joe" |
|
|
|
|
|
MS SQL Server 7 recursive stored procedure