Thanks for the prompt reply. Below is the code for the SP:

CREATE PROCEDURE dbo.GetOrderDetailByOrderID
(
@OrderID int
)

AS
SELECT Discount,
OrderID,
ProductID,
Quantity,
UnitPrice
FROM [Order Details]
WHERE OrderID = @OrderID
RETURN