求高人指点迷津 SQL如何模拟超市会员后屋过程

Question

课程设计的 搞晕了 求高手解答 这是我写的存储过程 等执行是出问题了 求解决
*会员购物存储过程*/ 
/*会员购物详单存储过程输入商品编号购买数量数量*/
CREATE PROC PROC_Desirables
@DBill_No varchar(8),@DDesirables_No varchar(8),@DGoods_No varchar(8),
@DQuantity int,@DUnitPrice Money,@DMoney Money
AS
BEGIN
SET @DMoney=(SELECT Discount*@DUnitPrice*@DQuantity
             FROM INTEGRAL,DESIRABLES
             WHERE Desirables_No=@DDesirables_No AND Goods_No=@DGoods_No) 
INSERT INTO DESIRABLES 
VALUES (@DBill_No,@DDesirables_No,@DGoods_No,@DQuantity,@DUnitPrice,@DMoney)
END/*会员购物小票存储过程输入会员编号购物时间*/             
CREATE PROC PROC_SALEBILL
@SMember_ID varchar(8),@SBill_No varchar(8),@SBuyTime date,@SAmount money,@Discount float
AS
BEGIN
SET @SAmount=(SELECT SUM(Money) FROM DESIRABLES WHERE Bill_No=@SBill_No) 
INSERT INTO SALEBILL
VALUES(@SMember_ID,@SBill_No,@SBuyTime,@SAmount,@Discount)
END

Answer 1

CREATE PROC PROC_Desirables
@DBill_No varchar(8),@DDesirables_No varchar(8),@DGoods_No varchar(8),
@DQuantity int,@DUnitPrice Money,@DMoney Money
AS
BEGIN
SELECT @DMoney= ISNULL(Discount*@DUnitPrice*@DQuantity,0)
FROM INTEGRAL,DESIRABLES
WHERE Desirables_No=@DDesirables_No AND Goods_No=@DGoods_No INSERT INTO DESIRABLES  
VALUES (@DBill_No,@DDesirables_No,@DGoods_No,@DQuantity,@DUnitPrice,@DMoney)
END
GO
/*会员购物小票存储过程输入会员编号购物时间*/   
CREATE PROC PROC_SALEBILL
@SMember_ID varchar(8),@SBill_No varchar(8),@SBuyTime date,@SAmount money,@Discount float
AS
BEGIN
SELECT @SAmount=ISNULL(SUM(Money),0) 
FROM DESIRABLES WHERE Bill_No=@SBill_No 
 
INSERT INTO SALEBILL
VALUES(@SMember_ID,@SBill_No,@SBuyTime,@SAmount,@Discount)
END