Query Missing Money orders...
Recently, 4 money orders stored in my files (each about $1,000.00) are missing.
Background: Years ago, something similar happened with Chase Bank. When I discussed this problem with the bank, in under 10 minutes, they queried and located the missing money orders and reprinted them for my use. Months later I found the original missing money orders (about $6,000) and returned them to the bank.
Now, with four money orders, the bank (a bank other than Chase this time) are asking for customer copy and additional information I cannot locate.
The second bank is telling me for $50/hour, they can go through some printouts to locate them visually. Well, they can spend 100 hours billing me $5,000 without even finding it which is not good.
What I am preparing to write to the bank is using the following information:
Name: My Name
Years money orders purchased: 2013, 2014, 2015
Product Name: Money Order
Amount criteria: $1000 each (900 <= money order amount <=1000 will be better).
To query their tables, I understand these tables could be huge but using some smart criteria listed above, a temp table could be produced with under 100 records:
Product Name: Money Order
Years money orders purchased: 2013, 2014, 2015
Name: My Name
Amount: 900 <= money order amount <=1000
Of course the final temp table needs to printout "cashed date", "Name cashed"
I hope you are familiar with a typical bank record keeping table structure to suggest/ prepare for me to communicate it to the bank in question. This query (or stored procedure) ideally will produce handful of records like:
ProductName Amount DatePurchased DateCashed CashedBy
Money Order $1000.00 x/x/2013 x/x/2014 abc
Money Order $ 900.00 x/x/2013
Money Order $1000.00 x/x/2014
Money Order $ 999.00 x/x/2014
Money Order $1000.00 x/x/2015 x/x/2015 abc
Money Order $1000.00 x/x/2015
This way, the bank could cancel above 4 items in bold and reprint them for my use.
Also, is 5 hour is enough time to produce this temp table. If so, I will have some results costing me only $250.
Thank you.
Background: Years ago, something similar happened with Chase Bank. When I discussed this problem with the bank, in under 10 minutes, they queried and located the missing money orders and reprinted them for my use. Months later I found the original missing money orders (about $6,000) and returned them to the bank.
Now, with four money orders, the bank (a bank other than Chase this time) are asking for customer copy and additional information I cannot locate.
The second bank is telling me for $50/hour, they can go through some printouts to locate them visually. Well, they can spend 100 hours billing me $5,000 without even finding it which is not good.
What I am preparing to write to the bank is using the following information:
Name: My Name
Years money orders purchased: 2013, 2014, 2015
Product Name: Money Order
Amount criteria: $1000 each (900 <= money order amount <=1000 will be better).
To query their tables, I understand these tables could be huge but using some smart criteria listed above, a temp table could be produced with under 100 records:
Product Name: Money Order
Years money orders purchased: 2013, 2014, 2015
Name: My Name
Amount: 900 <= money order amount <=1000
Of course the final temp table needs to printout "cashed date", "Name cashed"
I hope you are familiar with a typical bank record keeping table structure to suggest/ prepare for me to communicate it to the bank in question. This query (or stored procedure) ideally will produce handful of records like:
ProductName Amount DatePurchased DateCashed CashedBy
Money Order $1000.00 x/x/2013 x/x/2014 abc
Money Order $ 900.00 x/x/2013
Money Order $1000.00 x/x/2014
Money Order $ 999.00 x/x/2014
Money Order $1000.00 x/x/2015 x/x/2015 abc
Money Order $1000.00 x/x/2015
This way, the bank could cancel above 4 items in bold and reprint them for my use.
Also, is 5 hour is enough time to produce this temp table. If so, I will have some results costing me only $250.
Thank you.
Nakul Vachhrajani
Without a table structure and sample data, it would be very difficult for the experts to work out a prototype. Can you please provide some sample table structure and data from where this information is to be fetched?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well I can feel the headache you are facing, because I started to feel it, reading the problem.
Try to upload a sample database and explain the problem.
If you need a bank accountant's help, may be you ask somewhere else.
Try to upload a sample database and explain the problem.
If you need a bank accountant's help, may be you ask somewhere else.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.