--try~~
ALTER PROCEDURE dbo.FeeCheckoutToDetail AS INSERT INTO dbo.DetailBill
SELECT AA.CallID,BB.BusinessNo,
case AA.CallType
when 0 then
case BB.CallinFeeType
WHEN 0 THEN AA.FeeTime* BB.CallinPerMinFee
WHEN 1 THEN AA.FeeTime* BB.CallinPerTimeFee
END
Else
case BB.CalloutFeeType
WHEN 0 THEN AA.FeeTime* BB.CalloutPerMinFee WHEN 1 THEN AA.FeeTime* BB.CalloutPerTimeFee
END
END
,dbo.GetSimpDate(GETDATE()-1)
FROM AA,BB
where (AA.Callee=BB.BusinessCallinNo) or
(AA.Callee=BB.CalloutNo)
GO
ALTER PROCEDURE dbo.FeeCheckoutToDetail AS INSERT INTO dbo.DetailBill
SELECT AA.CallID,BB.BusinessNo,
case AA.CallType
when 0 then
case BB.CallinFeeType
WHEN 0 THEN AA.FeeTime* BB.CallinPerMinFee
WHEN 1 THEN AA.FeeTime* BB.CallinPerTimeFee
END
Else
case BB.CalloutFeeType
WHEN 0 THEN AA.FeeTime* BB.CalloutPerMinFee WHEN 1 THEN AA.FeeTime* BB.CalloutPerTimeFee
END
END
,dbo.GetSimpDate(GETDATE()-1)
FROM AA,BB
where (AA.Callee=BB.BusinessCallinNo) or
(AA.Callee=BB.CalloutNo)
GO
AS
INSERT INTO dbo.DetailBill
SELECT
AA.CallID,
BB.BusinessNo,
(CASE AA.CallType WHEN 0
THEN
(CASE BB.CallinFeeType
WHEN 0 THEN AA.FeeTime* BB.CallinPerMinFee
WHEN 1 THEN AA.FeeTime* BB.CallinPerTimeFee
END)
ELSE
(CASE BB.CalloutFeeType
WHEN 0 THEN AA.FeeTime* BB.CalloutPerMinFee
WHEN 1 THEN AA.FeeTime* BB.CalloutPerTimeFee
END)
END),
dbo.GetSimpDate(GETDATE()-1)
FROM
AA,BB
where
AA.Callee = BB.BusinessCallinNo
or
AA.Callee = BB.CalloutNo
GO
SELECT AA.CallID,BB.BusinessNo,
(
case AA.CallType when 0 then
(case BB.CallinFeeType
WHEN 0 THEN AA.FeeTime* BB.CallinPerMinFee
WHEN 1 THEN AA.FeeTime* BB.CallinPerTimeFee
END )
Else
(case BB.CalloutFeeType
WHEN 0 THEN AA.FeeTime* BB.CalloutPerMinFee WHEN 1 THEN AA.FeeTime* BB.CalloutPerTimeFee
END )
END)
,dbo.GetSimpDate(GETDATE()-1)
FROM AA,BB
where (AA.Callee=BB.BusinessCallinNo) or
(AA.Callee=BB.CalloutNo)
GO