merge to table into one table avoiding duplicated values

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

table 1

ID  Name   Address  Basic_Salary  Basic_Allowance
1   Moses  MTM      1000          500
2   GEO    NGL      3000          1500

Another table

table 2

ID  Name   Address  Salary        Allowance      Month
1   Moses  MTM      800           220            Nov

I Need the result

ID  Name   Address   Salary      Allowance   Month       Status
1   Moses  MTM       800         220         Nov         Paid
2   GEO    NGL       3000        1500        Nov         Not Paid

Can Any one help me how to solve it

Posted 8-Nov-14 3:12am

Moses Geo

Updated 8-Nov-14 3:15am

User 11060979

v2

Add a Solution

Comments

[no name] 8-Nov-14 9:18am

Think about something like this:
INSERT INTO DST .... WHERE NOT EXISTS (SELECT DST.ID ....)

Tomas Takac 8-Nov-14 9:34am

It is not clear where do you get the values of Month and Status. Yes, there is Month in table 2 but where did the other values come form? Do you want to insert new records like Bruno suggested or do you need to update changed records as well?

[no name] 8-Nov-14 9:46am

Uuups, you are completely right. I read the Q in a very lazy way. I focused only on "merge"...which does not really means always "insert", maybe OP needs simply to join the two tables. But that OP has to make clear.

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)

Manas Bhardwaj · Accepted Answer · 2014-11-08T04:12:00

Your question is not clear. But I am assuming that your first table is the Salary table and the second one which has been paid out.

Based on the vagueness of your question, I guess this is what you want:

SQL

SELECT
    Salary.ID,
    Salary.Name,
    Salary.Address,
    CASE WHEN Paid_Salary.Salary IS NULL THEN Salary.Basic_Salary ELSE Paid_Salary.Salary END AS Salary,
    CASE WHEN Paid_Salary.Allowance IS NULL THEN Salary.Basic_Allowance ELSE Paid_Salary.Allowance END AS Allowance,
    Paid_Salary.Month,
    CASE WHEN Paid_Salary.Salary IS NULL THEN 'Not Paid' ELSE 'Paid' END AS Status
FROM
    Salary LEFT JOIN Paid_Salary ON
        Salary.Name = Paid_Salary.Name