欧美精品1区2区3区,亚洲播播,欧美日韩大片在线观看

強(qiáng)檢器具數(shù)量如何統(tǒng)計(jì)

發(fā)布時(shí)間：2020-07-28 信息來(lái)源：瀏覽次數(shù)：次

1.增加存儲(chǔ)過(guò)程

create PROCEDURE [dbo].[GetQiangJianTJ]
   @QiJRQ varchar(10),
   @JieSRQ varchar(10)
AS
BEGIN
   SET NOCOUNT ON;
--生成預(yù)約情況統(tǒng)計(jì)臨時(shí)表
   Create table #tmp01(
   序號(hào) int identity,
   器具名稱 varchar(40),
   數(shù)量 int
   )

   declare @QiJBH varchar(30),@QiJMC varchar(200),@QiJSL int,@QiJZSL int ,@QiJMC1 varchar(200)
   set @QiJSL=0
   set @QiJZSL=0

   --定義主游標(biāo)
   declare cur_Tongj cursor for
   select QiJBH,QiJMC from QiJDM

   open cur_Tongj
   fetch next from cur_Tongj into @QiJBH,@QiJMC
   while @@fetch_status=0
   --select @QiJMC1=@QiJMC
   begin
   select @QiJMC1 =@QiJMC

   select @QiJSL=count(@QiJBH) from V_WeiTQJ where QiJBH=@QiJBH and ShouLRQ>=@QiJRQ
   and ShouLRQ<=@JieSRQ and WeiTFS like'%e-CQS系統(tǒng)網(wǎng)上預(yù)約%'

   select   @QiJZSL=@QiJZSL+@QiJSL
   if exists (select @QiJBH from V_WeiTQJ where QiJBH=@QiJBH and ShouLRQ>=@QiJRQ
   and ShouLRQ<=@JieSRQ and WeiTFS like'%e-CQS系統(tǒng)網(wǎng)上預(yù)約%')
   begin
   insert into #tmp01(器具名稱,數(shù)量)
   values(@QiJMC,@QiJSL)
   end


   fetch next from cur_Tongj into @QiJBH,@QiJMC
   end
   close cur_Tongj
   deallocate cur_Tongj
   insert into #tmp01(器具名稱,數(shù)量)
   values('總計(jì)：',@QiJZSL)
   select * from #tmp01
   drop table #tmp01
END

2.系統(tǒng)參數(shù)設(shè)置進(jìn)行對(duì)照