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 |
|
Srinishak1
Starting Member
4 Posts |
 Posted - 2014-03-02 : 10:12:38
|
| SQL Server 2008 How two to get tables records in same database and get column is changed. But changed column values should come from Table B. Not required Table A value to similar records. TABLE Ayear week Product Qty Price 2013 1 A 20 1502013 1 B 50 2002013 2 A 90 1002013 3 D 90 1002013 1 C 100 2052013 2 B 200 5552013 3 C 300 333TABLE Byear week Product Qty Price 2013 1 B 50 2002013 2 A 90 1112013 3 D 90 1002013 1 C 100 3502013 2 B 200 5552013 3 C 300 4442013 2 D 666 888But I need the result set like below 2013 2 A 20 7772013 1 A 20 1502013 1 B 50 2002013 2 A 90 1112013 3 D 90 1002013 1 C 100 3502013 2 B 200 5552013 3 C 300 4442013 2 D 666 888kindly help for this issue..Rajan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-03-02 : 11:25:22
|
| Your output is not clear. Can you explain how you got the first row?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SQL Server 2008 How two to get tables records in s