A
andyzhouap98111
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE PROCEDURE pro_outstanding_achievement
(@date1 datetime,@date2 datetime,@all_serve money output,@all_nurse money output,@all_cure money output,@all_goods money output, @all_money money output)
AS
declare @date3 varchar(20)
declare @date4 varchar(20)
set @date3=@date1
set @date4 =@date2+1
set @all_serve=(select isnull(sum(consume_money),0) from serve_note where consume_date >@date3 and consume_date < @date4)
set @all_nurse=(select isnull(sum(consume_money),0) from nurse_note where consume_date >@date3 and consume_date < @date4)
set @all_cure=(select isnull(sum(consume_money),0) from cure_note where consume_date >@date3 and consume_date < @date4)
set @all_goods=(select isnull(sum(consume_money),0) from goods_note where consume_date >@date3 and consume_date < @date4)
set @all_money=@all_serve+@all_nurse+@all_cure+@all_goods
GO
以上代码在日期比较时能得到结果但不准确为什么??????????????????
(@date1 datetime,@date2 datetime,@all_serve money output,@all_nurse money output,@all_cure money output,@all_goods money output, @all_money money output)
AS
declare @date3 varchar(20)
declare @date4 varchar(20)
set @date3=@date1
set @date4 =@date2+1
set @all_serve=(select isnull(sum(consume_money),0) from serve_note where consume_date >@date3 and consume_date < @date4)
set @all_nurse=(select isnull(sum(consume_money),0) from nurse_note where consume_date >@date3 and consume_date < @date4)
set @all_cure=(select isnull(sum(consume_money),0) from cure_note where consume_date >@date3 and consume_date < @date4)
set @all_goods=(select isnull(sum(consume_money),0) from goods_note where consume_date >@date3 and consume_date < @date4)
set @all_money=@all_serve+@all_nurse+@all_cure+@all_goods
GO
以上代码在日期比较时能得到结果但不准确为什么??????????????????