SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Update field with a value from another table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 03/28/2013 :  09:29:58  Show Profile  Reply with Quote
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 = X

The 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

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 03/28/2013 :  10:33:47  Show Profile  Reply with Quote
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 MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000