Write a Stored procedure in Ms Sql server or My SQL.

IN PROGRESS
Bids
28
Avg Bid (AUD)
$67
Project Budget (AUD)
$30 - $250

Project Description:
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

Parent

ID1
ID2
First Name
Last Name
Email
P1
P2
P3



Transaction

First Name
Last Name
Email
T1
T2
T3
T4

We need to create a output

ID1
ID2
First Name
Last Name
Email
T1
T2
T3
T4


The condition is

First match with

Transaction.First name = Parent.First name and Transaction.Last Name = Parent.Last Name and Transaction.Email = Parent.Email.

Second match with those transaction records that does not match the above will then be matched using the following criteria

Transaction.Last Name = Parent.Last Name and Transaction.Email = 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.

Skills required:
Microsoft, MySQL, Software Architecture, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 309
in 3 days
$ 60
in 1 days
Hire thanhlongfree
$ 34
in 3 days
$ 45
in 1 days
$ 50
in 1 days
Hire freshjah
$ 74
in 1 days
$ 55
in 3 days
Hire skapsl
$ 54
in 1 days
$ 30
in 0 days
Hire DeoTech
$ 45
in 3 days