iOpened = iTotal - iClosed>
>TEXT TO lcSQLStr TEXTMERGE noshow > SELECT ; > CAST(SUM(IIF(BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0)) AS I) as iOriginally_Closed, ; > CAST(SUM(IIF(ISNULL(cResolution_Codes_Fk) ,0,1)) AS I) as iClosed, ; > CAST(SUM(IIF(ISNULL(cResolution_Codes_Fk),1,0)) AS I) as iOpened, ; > CAST(COUNT(*) AS I) as iTotal ; > FROM Trans WHERE iBatch_Number = <<m.tiBatch_Number>> >endtext >lcSQLStr = STRTRAN(m.lcSQLStr, '##START_DATE##', m.lcStart_Date) >lcSQLStr = STRTRAN(m.lcSQLStr, '##END_DATE##', m.lcEnd_Date) >=RunSQL(m.lcSQLStr, 'c_BatchStatistics')>