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 - 2006-08-31 : 10:35:44
|
| John writes "I have two simple tables in a database.SWregister - lists all software against a particular userfield- devicename - contains numerous recordsfield- hwid - contains no valuesfield- devicename - contains numerous recordHWregister - lists all hardware against a particular userfield- masterid - contains numerous recordfield- pcwnumber - contains numerous recordI want to create a store procedure that will update the SW register with a HWID from the field- masterid where the devicename from both tables match.I want this because every time that I change one record in HWregister, i have to change multiple records in the SWregister" |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-08-31 : 12:21:20
|
| You don't have devicename in both tables, so how can you match them?It sounds to me like you either need to implement cascading updates, or you need to normalize your database schema. |
 |
|
|
|
|
|
strored procedure