Build 2 Microsoft SQL Server Stored Procedures

Completed Posted Aug 26, 2011 Paid on delivery
Completed Paid on delivery

Build 2 Microsoft SQL Server Stored Procedures the same results

## Deliverables

Build 2 Microsoft SQL Server Stored Procedures

Build 2 Microsoft SQL Server Stored Procedures the same results

Build two Stored Procedures (SP) in Microsoft SQL Server that SELECTs the most relevant price for each item based on the effective date of the price. One SP should use JOIN statement and the other should use a SELECT statement in the column selection section.

Tables:

ItemPrices - Prices to get data from

OrderItems - Items to look up prices for

SQLResluts - Results of SP

The SP should be written to handle large recordsets results that are returned and be compatible with Microsoft SQL Server 2005 and newer

See attached spreadsheet for results

Coder should use Microsoft Best Practices for building SP in SQL Server

Project ID: #3536482

About the project

7 proposals Remote project Active Aug 29, 2011

Awarded to:

amcsummers

See private message.

$17 USD in 2 days
(64 Reviews)
5.7

7 freelancers are bidding on average $12 for this job

szaszalexmcpd

See private message.

$17 USD in 2 days
(62 Reviews)
4.7
sanjoynemo

See private message.

$10 USD in 2 days
(22 Reviews)
4.6
impetussoft

See private message.

$10 USD in 2 days
(27 Reviews)
3.7
dhinojasl

See private message.

$7 USD in 2 days
(3 Reviews)
2.6
jobber4u

See private message.

$7 USD in 2 days
(1 Review)
2.1
bcssoftware

See private message.

$13 USD in 2 days
(0 Reviews)
0.5