邢唷>? S??R 衫\pKSK-LF Ba==hL,8X@"1@zArial1@zArial1@zArial1@唞媅SO1@唞媅SO1唞媅SO"?#,##0;"?\-#,##0"?#,##0;[Red]"?\-#,##0"?#,##0.00;"?\-#,##0.00#"?#,##0.00;[Red]"?\-#,##0.007*2_ "?* #,##0_ ;_ "?* \-#,##0_ ;_ "?* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ "?* #,##0.00_ ;_ "?* \-#,##0.00_ ;_ "?* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)yyyy/m/d\ h:mm:ss? ? ? ? ? ? ? ? ? ? ? ? ? ? ?   ? ,? *? +? )? 1  1  1  €€€€€€`# SQL Results SQL StatementVV`i!KCDMKCMCKKXYXF01120140:g癶CAD錧N6R 恌[b2.001120550}lf?uhV緥Y魚頞3.001120590}lf?昮[01120600f弳弔挌[N膵0O01120670 51USGr:gC韹 z廭緥01120760}lft簨01120770}lf弰g 01120780}lf従嫛01120790pe€b/g鶺@x01120800pe z0112081001190830}lf徖hKm€b/g01190850}lf廍e湒蕥璭f[01420100緗芠:g癶緥4.001470040闚hV闚h堦仺RS02111321‐W汻f[蜽aN鷁緥f[b2.502111330‐W錧 z豏遊021113500W鶺Yt021117400W鶺Yt z緥1.002122380鷁Q{錧 z錧 z蠎nUS鱊 z緥02123050齎E栧] zt1.502125010蜽^膲R02125020?b0W蟸Nmf[02125070?b0W_裇Nt02125080irNt02152061 螾Gr$R麐N*侹m匭N瀃`N02152062ERDASo忲NYtea螾ON瀃瓔02152063 zz-N N覊Km蠎ON瀃瓔02152064 peW[S0WuON瀃瓔02152065 螾Gr$R麐屫~ON瀃瓔02152066 peW[Ddq_Km蠎ON瀃瓔02153031銐恎Ddq_Km蠎f[02154032 wq\Km蠎錧 zKm蠎筫T 021540620Wt酧o`鹼邁緥Ddq_ea筫T 02154063ea€b/g蔛vQ擽(uDdq_ea筫T 02154065Ddq_Km蠎eag癳≧`Ddq_ea筫T 02190071 0W N鷁Q{膲RN緥021902710W N鷁Q{膲R緥02190770‐W錧 zKm諎€b/g02190830RNR楓mT檈02190950愬] z02191010 w儅N觺刧緥筫誰02191340^:Wf[02193280 痵僗錧 zW鷁 愾N鶺@x02193290痵僗鹼邁R恎021950504l噀0W(021950600W寣f[02195110 鷁Q{塠hQ€b/gNt02195130錧 z‐Wf[02221320 錧 z踒昩h z緥02221330 錧 z裿t膲R z緥02470620皊鉔tf[02470650噀.s纇"}02470660蟸Nm誰02470670錧 z0W(024708400247086002570070025700800257009002570210NN駛韹03110236陙≧S闚h5uP[酧o`錧 zf[b03110300袕≧6R鹼邁03110321錧係汷M?u03110420 5uP[5u飴R恎N緥03110666 6R鹼邁梴:gNw03110690o忲N錧 z03110720貧5u婼€b/g03110740裇5u係≧汻钀齆03110750裇5u係5ul钀齆03110763 5u汻鹼邁鐍5u軴烻t031107705u汻鹼邁陙≧艌n03110810}lf?uP[纇Km€b/g03112602 5u:gN袕≧6R鹼邁04110810褢崌f[鶺@x 酧o`褃f[N€b/gf[b04113140梴:gQ軂€b/g04113330鹼邁Nw!j媁04115490ITy橆vt04121260irT€Q俰簨3.504121270 Oa€b/g04121280irT€Q錧 z0412129005190700v戝] zuirNf[b05190830邩罷ir'`f[05196140o僫r鶺郪膥f[05197490o僫rTb鼅T瀃寶05197620褃x\㏑Kb05470160>yyO胈tf[06191190銼鉔Il韹06191290-N齎銼xQ噀.sf[06191520 皊鉔\O禰緗^yAm豐xvz06191540鶴Hrf[06191550皊鉔Ye瞼€b/g06191600仠艔xvz08110500y橆vt俰簨蟸Nmtf[b08110510uN袕\Ot08190420菓-崱{t08190470硚zO08470180篘汻D崘nt08570010"嵪~擽(u噀橯\O0857009008570110zO08570140鶺鷁O09111740誰媉蕥@b?e籰f[b101102903DSMAX/gf[b10140320筟hV 悑W10140360 罷 悑WPg檈N錧z10140430s^b桯r_緥10470600筶;u鶺@x5.010470610-N齎;u鶺@x11190070舉8n塠hQf[舉8n噀SNf[b11190550 ea€b/gN0Wt酧o`鹼邁111906500Wtf[鼅T11570000-N齎n欉槆eS12114050z?g瀃鯈N z?gf[b12193050a'Y)R韹13110391袕≧瓔脋f[SO瞼f[b13110394SO瞼 zNYef[簨13110395 SO瞼Yef[€b齹甠y:SkSugNt16190131-N;St16190140鉙T併塚Rut16190150鉙T佪OePNt4.516190310?Q鍅軴eP16190320蚹tZt16570060鉙T?N奮t€b/g16570070eP穅Ye瞼f[16570110畍'`舥tf[select * from (select distinct a.kcdm,a.kcmc,a.kkxy,a.xf from (select distinct kcdm,kcmc,kkxy,xf,xn,xq,sum(rs) zrs,bxsjl from ysjxrwb where xn='2014-2015' and xq='1' and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and (rs>0 or rs is not null) group by xn,xq,kcdm,kcmc,kkxy,xf,bxsjl ) a ,(select distinct kcdm,kcmc,kkxy,xf,xn,xq,sum(rs) zrs from jxrwb where xn='2014-2015' and xq='1' and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and jxjhh not like '%cx%' group by xn,xq,kcdm,kcmc,kkxy,xf ) b where a.kcdm=B.kcdm(+) and a.xn=B.xn(+) and a.xq=B.xq(+) and a.xf=b.xf(+) and b.zrs is null and (a.bxsjl<>'/f' or a.bxsjl is null)) order by kcdm SL{?B  L  H|  XT  *$|NR4F i g ; 9  i ] ' €  VZ0."\Hzj`^46nj-cc 衫 ,RD*N騑篴俴Ju簛 d褚MbP?_*+€%&殭櫃櫃?'殭櫃櫃?M HP LaserJet 400 M401 PCL 6|C€ 4dXXA4DINU"X 篍样MX SMTJH HP LaserJet 400 M401 PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueHPPCompositeUSBGetSerialNumberhppdvq01.dll_getDeviceSerialNumberWHPPInstallTimeConfighppdvq01.dll_getDevicePPMDuplexerWHPPCompositeUSBFilehppdvq01.dll_getDeviceSerialNumber_getDevicePPMDuplexerResolution600dpiFastResTrueDuplexVERTICALOrientationPORTRAITHPOrientRotate180FalsePaperSizeA4MediaTypeAUTOEMFSpoolingforPLSwoMopierTrueCollateOFFHPMediaTypeTreeviewPopupTrueColorModeMonoEconomodeFalseTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineAlternateLetterHeadFalseJPEGEnableAutoHPEnableGrafitCompressionTrueHPRequestObjectTagDumpFalseHPRequestNullStripCommandFalseHPHybridRenderSwitchHPHybridAutoHPPaperSizeALMConstraintsA5PrintQualityGroupPQGroup_2HPDocPropResourceDatahpchl117.cabHPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpcm4016.xmlHPLpiSelection156lpiHPEnableObjectTaggingTrueHPReverseScanLinesForDuplexFALSEHPEnablePageTimerFalseHPEnableNullStripsTrueHPEnableEfficientMonoFALSEHPEnableImageProcessingPathFALSEHPMonochromePrinterTRUEHPCallToWritePrinterRequiredTRUEHPMemoryManagerTrueHPGetCompressionRatioValue17MaxStripHeight64HPGetByteAlignedValueForWidth256HPGetDeltaRowHalfToneValue1HPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotateHPPrintOnBothSidesManuallyFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE117HPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionHPPngPassthroughTruePSAlignmentFileHPCLS117HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHubInet_SID_263_BID_514_HID_265HPConsumerCustomPaperTrueHPMHDLLNameHPFIE117HPPreAnalysisTrueIUPH!x滍倭NA? 褎嗯  I(炒砇└?訮h?A P8I郀O`L廅€W7Io摁倈迟5K@饼6贿焯lg撦欃I錘>€Mo#~ DCiKJ ^i鬫=m腶C?亚w?酬b#且樓徕隟h欮G件D滽蟅疅鎸j祕*喤黊8S搀栽V郎憣h搲J蠇蠎?Y??S詖灎Vo鮥P郾る閝鑾膡~:|\.酉鼁% 苤鲖閑崍谮yC@0忦樿觇網+W鍿淤7k賝_V>代岃洪{嘀/皠稾?6d-紨X趄eOa薑-_輭QK8X愞]捑繋m轫I殚E邵旫^??鑺縵?憗旄鵒]哈蟬( ╘BUN?遊殅镲肉K?騪絈鼭l館##\)3嶒y賡dI蒾)屓挆橌鲆鲆 t玉-聱3W恟鞤23椞>砱稕?剁|弮丫櫛?,U?磙蔸詈摱矢琰4懷 漐y<:" dXX??U} } } $} $                                                              !  " # $   % & ' ( ) * '  + , '  - . ' / 0 1 '  2 3 ' 4 5 6 ' 4 7 8 '  9 : '  ; < ' 4 = > '  ? @ ' / A B '  C D '  E F '  G H ' D€ l8888888888888888888888888888888 !"#$%&'()*+,-./0123456789:;<=>? I J '  !K !L !' ! "M "N "' " #O #P #' # $Q $R $' $4 %S %T %' %4 &U &V &' &/ 'W 'X '' '4 (Y (Z (' (/ )[ )\ )' )4 *] *^ *' *4 +_ +` +' +4 ,a ,b ,' ,( -c -d -' - .e .f .' .4 /g /h /' /4 0i 0j 0' 0 1k 1l 1' 14 2m 2n 2' 2/ 3o 3p 3' 34 4q 4r 4' 4 5s 5t 5' 5/ 6u 6v 6' 64 7w 7x 7' 7 8y 8r 8' 84 9z 9x 9' 9/ :{ :t :' :/ ;| ;x ;' ; <} <j <' < =~ = =' =4 >€ > > > ? ? ? ? D€ l8888888888888888888888888888888@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ @ @ @ A A A A B B B B C C C C D D D D E E E E4 F F F F" G G G G" H H H H I I I I J J J J K K K K L L L L M M M M4 N N N N O O O O P P P P Q Q Q Q R R R R S S S S( T T T T U U U U V V V V W W W W/ X X X X/ Y Y Y Y Z Z Z Z [ [ [ [ \ \ \ \ ] ] ] ] ^ ^ ^ ^ _ _ _ _ D€ l8888888888888888888888888888888`abcdefghijklmnopqrstuvwxyz{|}~ ` ` ` ` a a a a b b b b c c c c d d d d e e e e f f f f4 g g g g h h h h i i i i( j j j j k k k k l l l l m m m m n n n n o o o o p p p p q q q q" r r r r s s s s t t t t u u u u v v v v" w w w w x x x x y y y y z z z z { { { { | | | | } }  } }4 ~  ~  ~ ~     D€ l8888888888888888888888888888888€ € € € €                "    "    "    "    "   !  " " #  " $ %  " & '  " ( )   * +   , -   . /  4 0 1  4 2 3   4 5   6 7   8 9   : ;   < =   > /  4 ? 1  4 @ A   B C   D 9   E 7   F G   H I  D€ l8888888888888888888888888888888 J K   L M   N O   P Q   R S   T U V  W X V  Y Z V  [ \ V 4 ] ^ V  _ ` a  b c a  d e a  f g a  h i a  j k a  l m a  n o a  p q a  r s a  t u a  v w a  x y a  z  a ( { | a " } ~ a   € a    a    a    a         D€ l8888888888888888888888888888888    "    4                    /    /`8888888>@7 衫 輦' d褚MbP?_*+€%&殭櫃櫃?'殭櫃櫃?"d??U} $  ">@7 ?鄥燆鵒h珣+'迟0h08 HT`KSK-LF@€掍尯@€@缅尯?胀諟.摋+,0HP X`hpx   SQL ResultsSQL Statement 工作表  !"#$%&'()*+,-./0123456789:;<=>?@A?CDEFGHI?KLMNOPQ???Root Entry FP廷认?WorkbookhSummaryInformation(BDocumentSummaryInformation8J