<address id="thnfp"></address>
    

    <address id="thnfp"><th id="thnfp"><progress id="thnfp"></progress></th></address>
    <listing id="thnfp"><nobr id="thnfp"><meter id="thnfp"></meter></nobr></listing>
    


    
    
    
      以文本方式查看主題
    
        
    
      -  安易免費財務軟件交流論壇  (http://www.gangyx.cn/bbs/index.asp)
    
        --  用友財務軟件交流  (http://www.gangyx.cn/bbs/list.asp?boardid=7)
    
        ----  通2005總賬現存量整理后還是不對怎么辦?  (http://www.gangyx.cn/bbs/dispbbs.asp?boardid=7&id=23763)
    
        
    
          		
    
    
    
    
    
      --  作者：iabc3000
    
        --  發布時間：2009/8/16 15:40:17
    
        
        --  通2005總賬現存量整理后還是不對怎么辦?
    
        現存量整理后還是不對怎么辦?
        
    
          		
    
    
    
    
      --  作者：iabc3000
    
        --  發布時間：2009/8/16 15:40:42
    
        
        --  
    
        執行如下腳本:
        SELECT *
        FROM sysobjects
        WHERE name = \'tempcurrentstock\' DROP TABLE TempCurrentStock
        SELECT cWhCode, cInvCode, (CASE WHEN cFree1 = \'\' THEN NULL 
        ELSE cFree1 END) AS cFree1, (CASE WHEN cFree2 = \'\' THEN NULL 
        ELSE cFree2 END) AS cFree2, iainquantity AS iQuantity, CAST(0 AS FLOAT) 
        AS fOutQuantity, CAST(0 AS FLOAT) AS fInQuantity
        INTO TempCurrentStock
        FROM ia_subsidiary
        WHERE cvoutype = \'34\'
        GROUP BY ia_subsidiary.cWhCode, ia_subsidiary.cInvCode, ia_subsidiary.cFree1, 
        ia_subsidiary.cFree2, ia_subsidiary.iainquantity
        
    
          		
    
    

    
Channel