Click here to Skip to main content
14,882,036 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello to all,

I have two table in my DataBase

1) PaymentMaster

2) DailyCollectionMaster

In PaymentMaster I have

FinceID - Bigint
PartyID - Bigint
AcId - Bigint
Amount - float
Date - Date

In DailyCollectionMaster

DailyID - Bigint
PartyID - Bigint
AcId - Bigint
CollectionDate - date
Amount - float


Now on SQL Side i inserted data once in payment master and according to amount of payment master

i inserted daily records in DailycollectionMaster.

IF Record is not inserted in DailycollectionMaster in any Days.

How i can find which party record is not inserted in DailyCollection....


Thanks and Regards
Posted
Updated 4-Jul-14 3:19am
v4
Comments
[no name] 4-Jul-14 9:19am
   
Well, however you are doing this, you would be checking the return code for success or failure and logging the failures. Basic Error Checking 101.
[no name] 4-Jul-14 9:19am
   
you can do it with date condition. And check which date is missing from CollectionDate

1 solution

Refer to Subqueries with NOT EXISTS[^] and work out the solution yourself.
Take hint from the above comments.
   
v2
Comments
Jay1902 4-Jul-14 9:50am
   
Thank you so much it's work. thanks peter
Peter Leow 4-Jul-14 11:09am
   
You are welcome. Do accept this as solution if it helps

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900