Try this..

USE Northwind

GO

CREATE PROCEDURE Proc2 @CustomerID nchar(5)

AS

BEGIN

 DECLARE @OrderID int

 EXEC Proc1 @CustomerID, @OrderID OUTPUT

 SELECT Od.OrderID,

  ProductName,

  UnitPrice=ROUND(Od.UnitPrice, 2),

  Quantity,

  Discount=CONVERT(int, Discount * 100),

  ExtendedPrice=ROUND(CONVERT(money, Quantity * (1 - Discount) * Od.UnitPrice), 2)

 FROM  Products P, [Order Details]...