In your query you might have used distinct keyword while showing records, so duplicates are not showed.remove that distinct keyword.If still problem exists kindly post the query you used in it.Sridhar Thota.Editor: DNS Forum.

It may be in the issue in your SQL query. Do one thing try to run the SQL query in your query analyzer and get the result can fix it.

If you are getting proper query result then try to fix in the loading part from data reader to data table. If you share you code that will be easy to identify the issue.By NathanDirection is important than speed

If still you face the problem then paste your piece of code so that we can help you better.--------------------------------------------------------------------------------Give respect to your work, Instead of trying to impress your boss.