Getting duplicate records while retrieving data from the database using SQL 2012

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

Hi ,finally got the solution instead of distinct i also used groupby it solved my problem

What I have tried:

got the solution

Posted 2-Dec-16 11:13am

santhoshMadoori

Updated 7-Mar-17 8:33am

v5

Add a Solution

Comments

jgakenhe 2-Dec-16 18:59pm

Your going to need to find a couple of duplicates and compare each of them very closely, because they're not duplicates. You have so many columns, it is not surprising they appear to be duplicated. I word of advice to fix your problem and boost performance is to only bring back the columns you need.

CHill60 2-Dec-16 20:30pm

To get a meaningful solution try using Improve question link to give us some sample data from the tables (hint - make sure the sample data produces the problem and make sure it is a small sample). The exercise of finding suitable sample data may actually expose the problem to you

Tomas Takac 7-Mar-17 2:34am

As it seems there is not a one-to-one relationship between caseinformation and billing. You should investigate that instead trying to go around the problem using distinct or group by.

Richard Deeming 7-Mar-17 14:50pm

Editing your question to remove the content after a solution has been posted is extremely rude.

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)

NightWizzard · Answer 1 · 2017-03-07T07:46:00

If your billing table contains more than one billing information for the same case the JOIN will return a complete row for each billing info. A simple example to illustrate this:

caseID = 5

billing info A for caseID 5
billing info B for caseID 5

will return these rows:

5 with A
5 with B