正规股票配资官网,线上杠杆配资股票融资平台

強檢器具數量如何統計

發布時間：2020-07-28 信息來源：瀏覽次數：次

1.增加存儲過程

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

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

   --定義主游標
   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系統網上預約%'

   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系統網上預約%')
   begin
   insert into #tmp01(器具名稱,數量)
   values(@QiJMC,@QiJSL)
   end


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

2.系統參數設置進行對照

怀远配资,安全配资平台,杠杆配资服务,广东股票配资网