CREATE PROCEDURE InsertSalesOrderPart 
	@OrderNumber Int
	,@PartNumber Int
	,@Quantity Int
	,@ExtendedCost Money
AS

	Insert into SalesOrderPart
		(OrderNumber
		,PartID
		,Quantity
		,UnitPrice
		,ExtendedPrice
		,UnitCost
		,ExtendedCost
		)
	Select 
		@OrderNumber
		,p.PartID
		,@Quantity
		,p.Price
		,0 ExtendedPrice -- WHERE DOES THIS COME FROM
		,@ExtendedCost/@Quantity UnitCost
		,@ExtendedCost
	From Part p
	where
		P.PartID=@PartNumber

DECLARE	@OrderNumber Int = <replace with orderno>
	,@PartNumber Int = <replace with partId>
	,@Quantity Int = <replace with Quantity>
	,@ExtendedCost Money =<replace with cost>

Select 
	@OrderNumber
	,p.PartID
	,@Quantity
	,p.Price
	,0 ExtendedPrice --Where does this comefrom
	,@ExtendedCost/@Quantity UnitCost
	,@ExtendedCost
From Part p
where
	P.PartID=@PartNumber