Very Computer

I can't seem to get this work with even updating one field - I need to
potential update all of the fields ...

Here's where I'm at ..

UPDATE Jobs SET company  =
(Select company FROM ConvertedJobs
INNER JOIN Jobs ON Jobs.jobid = ConvertedJobs.jobid)
WHERE ConvertedJobs.Action ='Update';

Any help would be greatly appreciated !!

Happy Holidays ..

Bill

UPDATE j SET company  = c.company
 FROM ConvertedJobs c
INNER JOIN Jobs j ON j.jobid = c.jobid
WHERE c.Action ='Update'

Quote:> I have two tables in the same db.  Jobs and ImportedJobs.  The
ImportedJobs
> contains jobs that will update multiple records and multiple fields in the
> jobs table.

> I can't seem to get this work with even updating one field - I need to
> potential update all of the fields ...

> Here's where I'm at ..

> UPDATE Jobs SET company  =
> (Select company FROM ConvertedJobs
> INNER JOIN Jobs ON Jobs.jobid = ConvertedJobs.jobid)
> WHERE ConvertedJobs.Action ='Update';

> Any help would be greatly appreciated !!

> Happy Holidays ..

> Bill

try this

UPDATE Jobs SET company  = ConvertedJobs.company
FROM ConvertedJobs
 INNER JOIN Jobs ON Jobs.jobid = ConvertedJobs.jobid
 WHERE ConvertedJobs.Action ='Update';

--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), C*te, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

Quote:> I have two tables in the same db.  Jobs and ImportedJobs.  The
ImportedJobs
> contains jobs that will update multiple records and multiple fields in the
> jobs table.

> I can't seem to get this work with even updating one field - I need to
> potential update all of the fields ...

> Here's where I'm at ..

> UPDATE Jobs SET company  =
> (Select company FROM ConvertedJobs
> INNER JOIN Jobs ON Jobs.jobid = ConvertedJobs.jobid)
> WHERE ConvertedJobs.Action ='Update';

> Any help would be greatly appreciated !!

> Happy Holidays ..

> Bill

That did it .. Happy Holiday's once again !

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!