12:35:31 - IsConnectionValid True
12:35:31 - IsConnectionValid True
13:18:23 - IsConnectionValid True
13:18:29 - IsConnectionValid True
13:18:29 - IsConnectionValid True
13:18:32 - IsConnectionValid True
13:18:49 - IsConnectionValid True
13:18:49 - IsConnectionValid True
13:18:49 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code  Query
13:18:49 - IsConnectionValid True
13:19:28 - IsConnectionValid True
13:19:28 - IsConnectionValid True
13:19:41 - IsConnectionValid True
13:19:41 - IsConnectionValid True
13:19:41 - IsConnectionValid True
13:19:42 - IsConnectionValid True
13:19:42 - IsConnectionValid True
13:19:43 - IsConnectionValid True
13:19:43 - IsConnectionValid True
13:19:43 - IsConnectionValid True
13:19:43 - IsConnectionValid True
13:19:44 - IsConnectionValid True
13:19:44 - IsConnectionValid True
13:19:44 - IsConnectionValid True
13:19:45 - IsConnectionValid True