In Progress

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

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.

Skills: Microsoft, MySQL, Software Architecture, SQL

See more: writing a procedure, using in writing, need to write a project, sql server or, stored, stored procedures, sql software, MS SQL, sql final, good parent, transaction software, SQL Server Stored Procedures, stored procedure create sql, project server 2013, sql server database stored procedure web service wrapper, vaidhee, send sms sql server 2008 stored procedure, perl sql server execute stored procedure, sql transaction, mysql procedure output file, tiny tables, transaction sql, procedure mysql, mysql procedure file, mysql procedure

About the Employer:
( 44 reviews ) Ashfield, Australia

Project ID: #4485627

Awarded to:

skapsl

HI Sir I'm ready. SKAPL

$54 AUD in 1 day
(14 Reviews)
3.8

26 freelancers are bidding on average $69 for this job

kchg

Hello I'm interested with your project. I'll do it for you. Regards.

$309 AUD in 3 days
(270 Reviews)
9.3
freshjah

I am an expert at creating stored procedure in mysql and mssql

$74 AUD in 1 day
(121 Reviews)
7.2
cheapexcell

Expert in TSQL. Will be done in just a few hours

$60 AUD in 1 day
(161 Reviews)
6.6
thanhlongfree

Hi. I can do it for you right now.

$34 AUD in 3 days
(33 Reviews)
5.8
oozeit

We can create this easily. Let's start this right now and we will finish this in 3 hours

$45 AUD in 1 day
(25 Reviews)
5.4
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$74 AUD in 1 day
(32 Reviews)
5.0
smshafiqulislam

Hi, I am sql expert. Did lots of project. I can do your task in a perfect way. Please check my profile.

$50 AUD in 1 day
(31 Reviews)
5.2
Reza2012

Hi I have 10 years experience in Database Administration. I have done huge work in my work environment and freelancer also. Please see my profile. Thanks.

$55 AUD in 3 days
(36 Reviews)
5.0
tuanlm101

Hello, it'll be easy to implement. I can finish the job in a few minutes!

$30 AUD in 0 days
(12 Reviews)
4.9
DeoTech

Hi I have more than 12 years experience in MS SQL I can do your task. Regards.

$45 AUD in 3 days
(12 Reviews)
4.4
vks75

Hi, I can do this. Please look at your PMB for details.

$55 AUD in 0 days
(5 Reviews)
3.7
abbaco

Hi, I'm a experienced mysql administrator and php developer. This is a very fast project for me and I can do it right now if you agree. I'm online so I can start to work right now if you accept my bid.

$45 AUD in 3 days
(8 Reviews)
3.5
igotmail9

Hello sponsor, We are a dynamic, virtual, experienced MNC employees decided to capture freelance market. Rich in software development and work experience, technical and professional expertise. Consult us for your qu More

$34 AUD in 0 days
(4 Reviews)
2.9
manohartvs

Hi There, you can see my profile reviews and note that I tend to deliver projects very quickly. I can have the procedure written for you ASAP! Your description is clear and straight forward.

$35 AUD in 0 days
(2 Reviews)
2.5
krthrinod

We have a team of 4 people who are OCJP [url removed, login to view] love to do coding in Java ,Mysql and crazy about [url removed, login to view] have done following project till now by using Java,Mysql,Oracle .So we are right person in helping you to f More

$30 AUD in 1 day
(0 Reviews)
0.0
MartinasOctavian

Hello, this is a very easy project and i can deliver it in less than an hour. Good Day!

$30 AUD in 1 day
(0 Reviews)
0.0
arvi15

Hi, I have 10 years of experience in SQL server and C#. I can deliver this procedure in quick time Refer us on terasite thanks Aravind

$35 AUD in 1 day
(0 Reviews)
0.0
singharun7

i can do your project very easily if you have any query about me come and chat

$66 AUD in 2 days
(1 Review)
1.9
TUYLV

I can finish in 3 hours. Please choose me!.

$30 AUD in 0 days
(0 Reviews)
0.0
pravinreddy

I can get this completed asap.

$30 AUD in 0 days
(0 Reviews)
0.0