I am trying to get a price of an item then inserting into a table. When I test the individual sp's they work fine but when I do an exec in the procedure it will not get the price.

Hi,

 

With me this code is working fine on my computer:

 

Create procedure [dbo].[proc_PurchaseDetail_Insert]

      @PurchaseId int,

      @PurchaseItemId int,

      @Qty int

As

 

DECLARE @Price int

 

EXEC proc_PurchaseItem_GetPrice@PurchaseItemId, @Price output

 

INSERT INTO tblPurchaseDetail

(

      PurchaseId,

      PurchaseItemId,

      Qty,

      Price

)

  VALUES

(

      @PurchaseId,

      @PurchaseItemId,

      @Qty,

      @Qty * @Price

)

 

If this doesn’t work provide me also the code of your “proc_PurchaseItem_GetPrice” procedure.