Write a Stored procedure in Ms Sql server or My SQL.
This project was successfully completed by skapsl for $54 AUD in a day.Get free quotes for a project like this
Project Budget$30 - $250 AUD
Completed In1 day
You should be good in writing Stored procedures using MySQL or MS SQL SERVER
You should be able to deliver this project within the next few hours.
This is a tiny project - Quick and easy
We have two tables
We need to create a output
The condition is
First match with
[url removed, login to view] name = [url removed, login to view] name and [url removed, login to view] Name = [url removed, login to view] Name and [url removed, login to view] = Parent.Email.
Second match with those transaction records that does not match the above will then be matched using the following criteria
[url removed, login to view] Name = [url removed, login to view] Name and [url removed, login to view] = Parent.Email.
The final output file will have all of the transaction records with only those records that matched with the ID1 and ID2 from Parent.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online