- Katılım
- 29 Haziran 2005
- Mesajlar
- 158
- Excel Vers. ve Dili
-
MS Office Professional Plus 2013 64 Bit -Eng
MSSQL 2012 R2 64 Bit
Şu SQL kodunu VBA koduna çevirebilirmisiniz ?
SELECT SUM(LG_086_01_KSLINES.AMOUNT) AS Giren
FROM LG_086_KSCARD INNER JOIN
LG_086_01_KSLINES ON LG_086_KSCARD.LOGICALREF = LG_086_01_KSLINES.CARDREF
WHERE (LG_086_01_KSLINES.DATE_ BETWEEN CONVERT(DATETIME, '2009-03-30 00:00:00', 102) AND CONVERT(DATETIME, '2009-03-30 00:00:00', 102)) AND
(LG_086_01_KSLINES.SIGN = 0) AND (LG_086_KSCARD.LOGICALREF = 1)
SELECT SUM(LG_086_01_KSLINES.AMOUNT) AS Giren
FROM LG_086_KSCARD INNER JOIN
LG_086_01_KSLINES ON LG_086_KSCARD.LOGICALREF = LG_086_01_KSLINES.CARDREF
WHERE (LG_086_01_KSLINES.DATE_ BETWEEN CONVERT(DATETIME, '2009-03-30 00:00:00', 102) AND CONVERT(DATETIME, '2009-03-30 00:00:00', 102)) AND
(LG_086_01_KSLINES.SIGN = 0) AND (LG_086_KSCARD.LOGICALREF = 1)