469,325 Members | 1,404 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

How to update table that data came to another table using update trigger

Hi everyone, I hope someone can help me out!

I have 2 tables with 2 related colums: CHARGE_BREAKDOWN with Approvalcode and td columns while MERCHANT_BANK has Appcode and trandate columns.

The data from charge_breakdown cames to our POS which was updated daily while Merchant_bank data cames from the bank and it's a text file only. Merchant_bank table insert data by using data transformation.

What I need is to insert ORNo from Charge_breakdown to Merchant_bank and update flag column of Merchant_bank that the condition is if the approvalcode and transactiondate is the same in 2 tables set flag equal to 1 and if not set flag equal to 0.

Please send me a script on this problem.

Many thanks in advance.
Aug 16 '07 #1
0 1039

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Rustam Bogubaev | last post: by
8 posts views Thread by Jan van Veldhuizen | last post: by
3 posts views Thread by takilroy | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
18 posts views Thread by Bill Smith | last post: by
25 posts views Thread by Neo Geshel | last post: by
2 posts views Thread by Josué Maldonado | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.