Completed

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
Employer working
Completed by:
Project Budget
$30 - $250 AUD
Completed In
1 day
Total Bids
28
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

[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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online