当前统计日期,统计月份

《当前统计日期,统计月份》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、蚅虿肁薅薁螈膃莇蒇螇芆膀袅螆肅莆螁螆膈艿蚇螅芀蒄薃螄羀芇葿螃肂蒂螈螂膄芅蚄袁芇蒁薀袀羆芃蒆袀腿葿蒂衿芁莂螀袈羁薇蚆袇肃莀薂袆膅薆蒈羅芇莈螇羄羇膁蚃羄聿莇蕿羃节腿薅羂羁蒅蒁羁肄芈螀羀膆蒃蚆罿芈芆薂聿羈蒁蒈肈肀芄螆肇膃蒀蚂肆莅芃蚈肅肅薈薄蚂膇莁蒀蚁艿薆蝿蚀罿荿蚅虿肁薅薁螈膃莇蒇螇芆膀袅螆肅莆螁螆膈艿蚇螅芀蒄薃螄羀芇葿螃肂蒂螈螂膄芅蚄袁芇蒁薀袀羆芃蒆袀腿葿蒂衿芁莂螀袈羁薇蚆袇肃莀薂袆膅薆蒈羅芇莈螇羄羇膁蚃羄聿莇蕿羃节腿薅羂羁蒅蒁羁肄芈螀羀膆蒃蚆罿芈芆薂聿羈蒁蒈肈肀芄螆肇膃蒀蚂肆莅芃蚈肅肅薈薄蚂膇莁蒀蚁艿薆蝿蚀罿荿蚅虿肁薅薁螈膃莇蒇螇芆膀袅螆肅莆螁螆

2、膈艿蚇螅芀蒄薃螄羀芇葿螃肂蒂螈螂膄芅蚄袁芇蒁薀袀羆芃蒆袀腿葿蒂衿芁莂螀袈羁薇蚆袇肃莀薂袆膅薆蒈羅芇莈螇羄羇膁蚃羄聿莇蕿羃节腿薅羂羁蒅蒁羁肄芈螀羀膆蒃蚆罿芈芆薂聿羈蒁蒈肈肀芄螆肇膃蒀蚂肆莅芃蚈肅肅薈薄蚂膇莁蒀蚁艿薆蝿蚀罿荿蚅虿肁薅薁螈膃莇蒇螇芆膀袅螆肅莆螁螆膈艿蚇螅芀蒄薃螄羀芇葿螃肂蒂螈螂膄--当前统计日期，统计月份--------------------------------------------------------------------------------selectGETDATE()as当前统计日期,convert(char

3、(10),month(GETDATE()))+'月'as统计月份----------------------------------------------------------------------------------统计当月认证户数--------------------------------------------------------------------------------selectcount(distinctzhh)as当月认证户数fromdklwheremonth(fssj)=month(getdate())

4、----------------------------------------------------------------------------------统计当月总体修改情况--------------------------------------------------------------------------------selectt2.zpcas总共发送批次,t1.xgpcas发生修改批次,convert(char(10),t1.xgpc/convert(float,t2.zpc)*100)+'%'as修改比率from

5、(selectcount(distincthzhm)asxgpcfromdklwhererzjgin(01,02)andmonth(fssj)=month(getdate()))t1,(selectcount(distincthzhm)aszpcfromdklwheremonth(fssj)=month(getdate()))t2----------------------------------------------------------------------------------统计当月每操作员情况表---------------

6、-----------------------------------------------------------------select'编号'+convert(char(10),ta.czybh)as操作员代码,ta.aas扫描发票数,tb.bas一次认证通过,convert(char(10),(tb.b/CONVERT(float,ta.a))*100)+'%'as一次通过率from(selectczybh,count(czybh)asafromdbo.DKLwhererzjgin(00,01)--andczybhnotin--('

7、004','009','010')andmonth(lrsj)=month(GETDATE())groupbyczybh)ta,(selectczybh,count(czybh)asbfromdbo.DKLwhererzjg=00andmonth(lrsj)=month(GETDATE())groupbyczybh)tbwhereta.czybh=tb.czybhorderby扫描发票数desc---------------------------------------------------------------------------

8、-------合计-------------------------------------------------------------------------