![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.08 » View Incident Report |
![]() |
Reported By: Fernando Dias Reported On: 1/17/2012 For: Version 2.07 Build 1 |
Parameter values: cf2 = 1137 di2 = 2011-01-01 cf1 = 1137 di1 = 2011-01-01 df1 = 2011-12-31 Query: SELECT * FROM ( SELECT CAST(NULL AS DATE) AS DataMov, 'Saldo Anterior' AS Descricao, '' AS TipoDoc, CAST(NULL AS INTEGER) AS NumReg, '' AS NumDoc, SUM(ValorMovCS) AS Valor , CAST(NULL AS INTEGER) AS Diario, CAST(NULL AS INTEGER) AS NumLanc FROM MovFor WHERE CodFornecedor = :cf2 AND DataMov < :di2 UNION ALL SELECT DataMov, Descricao, TipoDoc, NumReg, NumDoc, ValorMovCS, Diario, NumLanc FROM MovFor WHERE CodFornecedor = :cf1 AND DataMov >= :di1 AND DataMov <= :df1 ) AS TmpTbl
This web page was last updated on Wednesday, February 8, 2023 at 07:22 AM | Privacy Policy![]() © 2023 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |