top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Update from one table to another table using SQL Server 2008

+2 votes
419 views

I want to update data from one table to another table with year condition.
(OR)
To Update one table based on another table using INNER JOIN

posted Jun 19, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

I want to update data from one table to another table with year condition.

UPDATE pgptrans SET dcamt1 = t2.ecamt1 FROM pgptrans t1 INNER JOIN pgptrans060713 t2 ON t1.empcode = t2.empcode WHERE t1.empcode LIKE '130%' AND t1.yrmn = '201308' AND t2.yrmn = '201207'

To Update one table based on another table using INNER JOIN

UPDATE t1 SET t1.status = 1 FROM table1 t1 INNER JOIN table t2 ON t1.Id = t2.ID WHERE t2.num = 15 
answer Jun 22, 2015 by Manikandan J
Similar Questions
+3 votes

This is the Sales_Import table, where the account number field needs to be updated:
LeadID AccountNumber

147 ********** 
150 ********** 
185 7006100100007267039

And this is the RetrieveAccountNumber table, where I need to update from:
LeadID AccountNumber

147 7006100100007266957 
150 7006100100007267039 
+3 votes

I have a table that looks something like this:

SetId ID Premium 
2012 5 Y 
2012 6 Y 
2013 5 N 
2013 6 N

I want to update the 2013 records with the premium values where the setid equals 2012.
So after the query it would look like this:

SetId ID Premium 
2012 5 Y
 2012 6 Y 
2013 5 Y 
2013 6 Y

Any help greatly appreciated

...