How to insert the row from table 2 to table1

Question

1.00/5 (1 vote)

See more:

how to insert the row from table 2 to table 1 if the ledgerhead, mainledger, subledger of the row doesnot exits on table1. eg

table 1
ledgerhead mainledger subledger dr cr
1 ASSETS ACCUMULATED LOSS - 1245.00 0.00 1245.00
2 ASSETS CASH & BANK BALANCES CASH-IN-HAND 2141639.00 6245.00
3 ASSETS CASH & BANK BALANCES COSYS BANK 4444.00 0.00 4444.00
4 ASSETS CASH & BANK BALANCES GLOBAL IME BANK 12121.00 0.00
5 ASSETS RECEIVABLES INTEREST RECEIVABLES 15000.00 0.00
6 LIABILITIES SAVINGS Double Deposit Saving 3434.00 0.00 3434.00

table 2
ledgerhead mainledger subledger dr cr
1 ASSETS CASH & BANK BALANCES CASH-IN-HAND 2141639.00 6245.00
2 ASSETS CASH & BANK BALANCES GLOBAL IME BANK 12121.00 0.00
3 ASSETS RECEIVABLES INTEREST RECEIVABLES 15000.00 0.00
4 ASSETS CASH & BANK BALANCES KIST BANK LTD. 3434.00 0.00 3434.00
5 LIABILITIES SAVINGS Fixed Deposit 2 Year 0.00 12134.00

that i want to insert the row from table2 is row 4 and 5 because the ledgerhead, mainledger and subledger field of row 4,5 doesnot match to table1 rows data.

Please help me ...

Posted 11-Jun-14 0:43am

User 10734264

Updated 11-Jun-14 0:47am

v2

Add a Solution

Comments

[no name] 11-Jun-14 7:28am

Why do you think that the data in the fields has to match before you can INSERT INTO? As long as the data types match there should not be a problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

User 10734264 · Accepted Answer · 2014-06-11T18:24:00

SQL

INSERT INTO #tempLedgerFinalBalance
                SELECT * FROM #tempLedgerPrevious t2 WHERE
        NOT EXISTS
        (
           SELECT * FROM #tempLedgerFinalBalance as t1 WHERE t1.LedgerHead=t2.LedgerHead AND t1.MainLedger=t2.MainLedger AND t1.SubLedger=t2.SubLedger
        )

works fine