The following question uses Microsoft SQL Server.

Create a simple stored procedure that does not expect any parameters and contains a single T-SQL statement.

1. Create the stored procedure as PurchaseOrderInfo
2. This stored Procedure should return a result set consisting of ProductName, PurchaseOrderID, PurchaseOrderDetailID, OrderDate, TotalDue and ReceivedQty.
3. Refer to the schema AdventureWorks2012.Production and AdventureWorks2012.Purchasing to access the necessary tables needed to generate the following output.
4. EXECUTE the stored procedure in 2 ways.
   1. Using the simple EXECUTE keyword, and
   2. Using EXECUTE command by adding a WITH RESULT SETS statement.
5. Show the CREATE PROC, both the EXECUTE statements and the two sets of result sets.
6. The result should yield 8845 records.