第一次处破女小芳的感觉,最美情侣中文在线电影资源,欧美精品成人a在线观看,伊人久久精品无码av一区

1.創(chuàng)建存儲(chǔ)過(guò)程

create  PROCEDURE [dbo].[GetFeiQiangJianTJ]     @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 @QiJMC varchar(200),@QiJSL int,@QiJZSL int     set @QiJSL=0      set @QiJZSL=0     --定義主游標(biāo)     declare cur_Tongj cursor for     select  QiJMC from V_WeiTQJ group by QiJMC          open cur_Tongj     fetch next from cur_Tongj into @QiJMC     while @@fetch_status=0     begin          select @QiJSL=sum(YangPSL) from V_WeiTQJ where QiJMC=@QiJMC and ShouLRQ>=@QiJRQ      and ShouLRQ<=@JieSRQ and ISNULL(WeiTFS,'') <>'e-CQS系統(tǒng)網(wǎng)上預(yù)約'          select @QiJZSL=sum(YangPSL) from V_WeiTQJ where  ShouLRQ>=@QiJRQ      and ShouLRQ<=@JieSRQ and ISNULL(WeiTFS,'') <>'e-CQS系統(tǒng)網(wǎng)上預(yù)約'               if   exists (select YangPSL from V_WeiTQJ where QiJMC=@QiJMC and ShouLRQ>=@QiJRQ      and ShouLRQ<=@JieSRQ and ISNULL(WeiTFS,'') <>'e-CQS系統(tǒng)網(wǎng)上預(yù)約')     begin     insert into #tmp01(器具名稱,數(shù)量)             values(@QiJMC,@QiJSL)     end                 fetch next from cur_Tongj into @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ì)照