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 |
jbuggs
Starting Member
1 Post |
Posted - 2013-03-28 : 09:29:58
|
I have two tables (Opportunity and Project). Basically, I just want to update the opportunity name field based on the project name field where the project code = XThe opportunity table does not have any exact matches when comparing the project table. Thus, I am going to specify the update based on the project code.Thanks in Advance!James Bunn |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-28 : 10:33:47
|
so does that mean entire oppurtunity table name fields will have same value? Or do you've multiple records in project table with code='X'------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|