SELECT COUNT(1) AS TotalCount FROM TB_AIP_FILE_JOB_LOG A WHERE A.LogDate BETWEEN CONVERT(DATETIME, @startDate, 20) AND CONVERT(DATETIME, @endDate, 20)