问题原因: |
跟踪到临时表:SELECT cdept_id,ccode,citem_id,dbill_date,i_id,iperiod,csign,isignseq,ino_id,inid,ibook,iflag,cdigest,cexch_name,md,mc, md_f,mc_f,nfrat,nd_s,nc_s,csettle,cn_id,dt_date,cperson_id,ccus_id,csup_id,citem_class,cname,ccode_equal,cdefine1,cdefine2, cdefine3,cdefine4,cdefine5,cdefine6,cdefine7,cdefine8,cdefine9,cdefine10,cdefine11,cdefine12,cdefine13,cdefine14,cdefine15, cdefine16 INTO [tempdb]..[MxzZL2K20864465] FROM GL_accvouch WHERE citem_class='01' AND citem_id='010200002' AND 1=1 AND ibook=1 AND ccode In ('5501010403') AND iperiod >= 6 AND iperiod<=6 AND (iflag IS NULL Or iflag=2) ORDER BY dbill_date,isignseq,ino_id,inid 临时表数据还全的。都还正常,但是显示不全 |