Hi.
I am Sorry that I don't know how to ask question for my Scenario. Thats why I just used "How to update qty into table2
from table1? "
This is the scenario of one of my customer
Table-1 Subscription Master(News Paper) - Received Subscription
CustCode Name Copies date Agent
0001 XXX 10 10.05.2015 AKL
0001 XXX 5 15.05.2015 AKL
0001 XXX 7 18.05.2015 AKL
System has to instruct the Agent for delivery just like below
So I insert data from Table-1 to table-2
Using below code
INSERT INTO [dbo.Table-2] ( Custcode,Copies,Date,Agent)
SELECT CustCode,Copies,Date,Agent FROM [dbo.table-1]
Result is like below
0001 10 10.05.2015 AKL
0001 5 15.05.2015 AKL
0001 7 18.05.2015 AKL
And I have try to update Qty using below code
UPDATE [dbo.Tab ...
Go to the complete details ...