Build 2 Microsoft SQL Server Stored Procedures

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