10:31:40 - IsConnectionValid True 10:31:41 - IsConnectionValid True 10:31:42 - IsConnectionValid True 10:31:48 - IsConnectionValid True 10:31:48 - IsConnectionValid True 10:31:53 - IsConnectionValid True 10:31:59 - IsConnectionValid True 10:31:59 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:31:59 - IsConnectionValid True 10:31:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:32:09 - IsConnectionValid True 10:32:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:32:15 - IsConnectionValid True 10:32:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:34:13 - IsConnectionValid True 10:34:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:34:21 - IsConnectionValid True 10:34:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:35:03 - IsConnectionValid True 10:35:03 - IsConnectionValid True 10:35:15 - IsConnectionValid True 10:35:16 - IsConnectionValid True 10:35:19 - IsConnectionValid True 10:35:19 - IsConnectionValid True 10:35:22 - IsConnectionValid True 10:35:39 - IsConnectionValid True 10:35:42 - IsConnectionValid True 10:35:42 - IsConnectionValid True 10:35:50 - IsConnectionValid True 10:35:52 - IsConnectionValid True 10:35:52 - IsConnectionValid True 10:36:40 - IsConnectionValid True 10:36:41 - IsConnectionValid True 10:36:43 - IsConnectionValid True 10:36:43 - IsConnectionValid True 10:36:45 - IsConnectionValid True 10:36:45 - IsConnectionValid True 10:37:10 - IsConnectionValid True 10:37:10 - IsConnectionValid True 10:37:17 - IsConnectionValid True 10:37:17 - IsConnectionValid True 10:37:26 - IsConnectionValid True 10:37:27 - IsConnectionValid True 10:37:27 - IsConnectionValid True 10:37:30 - IsConnectionValid True 10:37:30 - IsConnectionValid True 10:38:58 - IsConnectionValid True 10:39:03 - IsConnectionValid True 10:39:03 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:39:04 - IsConnectionValid True 10:39:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:39:09 - IsConnectionValid True 10:39:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:39:13 - IsConnectionValid True 10:39:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:39:43 - IsConnectionValid True 10:39:49 - IsConnectionValid True 10:45:36 - IsConnectionValid True 10:45:36 - IsConnectionValid True 10:45:36 - IsConnectionValid True 10:45:36 - IsConnectionValid True 10:45:37 - IsConnectionValid True 10:45:37 - IsConnectionValid True 10:45:37 - IsConnectionValid True 10:45:38 - IsConnectionValid True 10:45:38 - IsConnectionValid True 10:45:53 - IsConnectionValid True 10:45:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:46:02 - IsConnectionValid True 10:46:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:46:10 - IsConnectionValid True 10:46:10 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 10:46:27 - IsConnectionValid True 10:52:06 - IsConnectionValid True 10:52:11 - IsConnectionValid True 10:52:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:15 - IsConnectionValid True 10:52:15 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 10:56:11 - IsConnectionValid True 10:56:16 - IsConnectionValid True 10:56:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:56:19 - IsConnectionValid True 10:56:19 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 10:56:25 - IsConnectionValid True 10:57:17 - IsConnectionValid True 10:57:21 - IsConnectionValid True 10:57:26 - IsConnectionValid True 10:57:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:57:29 - IsConnectionValid True 10:57:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:57:35 - IsConnectionValid True 10:57:35 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 10:57:40 - IsConnectionValid True 10:57:57 - IsConnectionValid True 10:57:58 - IsConnectionValid True 10:57:59 - IsConnectionValid True 10:57:59 - IsConnectionValid True 10:58:02 - IsConnectionValid True 10:58:05 - IsConnectionValid True 10:58:08 - IsConnectionValid True 10:58:11 - IsConnectionValid True 10:58:14 - IsConnectionValid True 11:00:57 - IsConnectionValid True 11:01:05 - IsConnectionValid True 11:01:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:01:08 - IsConnectionValid True 11:01:08 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:01:17 - IsConnectionValid True 11:01:34 - IsConnectionValid True 11:01:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:01:36 - IsConnectionValid True 11:01:36 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:02:09 - IsConnectionValid True 11:02:14 - IsConnectionValid True 11:02:14 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:02:34 - IsConnectionValid True 11:03:53 - IsConnectionValid True 11:04:06 - IsConnectionValid True 11:04:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:04:09 - IsConnectionValid True 11:04:09 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:04:21 - IsConnectionValid True 11:06:09 - IsConnectionValid True 11:06:17 - IsConnectionValid True 11:06:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:06:22 - IsConnectionValid True 11:06:22 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:06:30 - IsConnectionValid True 11:39:22 - IsConnectionValid True 11:39:36 - IsConnectionValid True 11:39:56 - IsConnectionValid True 11:40:05 - IsConnectionValid True 11:40:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:23:20 - IsConnectionValid True 14:23:46 - IsConnectionValid True 14:23:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:23:50 - IsConnectionValid True 14:23:50 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:24:08 - IsConnectionValid True 14:25:16 - IsConnectionValid True 14:25:32 - IsConnectionValid True 14:25:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25:36 - IsConnectionValid True 14:25:36 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:25:43 - IsConnectionValid True 14:25:58 - IsConnectionValid True 14:28:47 - IsConnectionValid True 14:29:04 - IsConnectionValid True 14:29:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:29:49 - IsConnectionValid True 14:29:49 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:30:21 - IsConnectionValid True 14:31:36 - IsConnectionValid True 14:31:42 - IsConnectionValid True 14:31:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:32:06 - IsConnectionValid True 14:32:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:32:11 - IsConnectionValid True 14:32:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:38:42 - IsConnectionValid True 14:38:42 - SELECT DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3 Query 14:38:42 - IsConnectionValid True 14:38:42 - IsConnectionValid True 14:38:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:38:43 - IsConnectionValid True 14:38:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:38:49 - IsConnectionValid True 14:39:08 - IsConnectionValid True 14:39:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:39:14 - IsConnectionValid True 14:39:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND Name LIKE @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:39:18 - IsConnectionValid True 14:39:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:41:46 - IsConnectionValid True 14:41:50 - IsConnectionValid True 14:41:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:41:51 - IsConnectionValid True 14:41:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:41:54 - IsConnectionValid True 14:41:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:41:56 - IsConnectionValid True 14:41:56 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:41:59 - IsConnectionValid True 14:41:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:42:34 - IsConnectionValid True 14:42:34 - SELECT DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3 Query 14:42:34 - IsConnectionValid True 14:42:34 - IsConnectionValid True 14:42:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:42:35 - IsConnectionValid True 14:42:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:18 - IsConnectionValid True 14:45:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:45:24 - IsConnectionValid True 14:45:29 - IsConnectionValid True 14:45:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:35 - IsConnectionValid True 14:45:35 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:45:47 - IsConnectionValid True 14:45:55 - IsConnectionValid True 14:45:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:46:11 - IsConnectionValid True 14:46:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:46:15 - IsConnectionValid True 14:46:15 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:47:47 - IsConnectionValid True 14:47:59 - IsConnectionValid True 14:47:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:48:03 - IsConnectionValid True 14:48:03 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:23:24 - IsConnectionValid True 15:23:33 - IsConnectionValid True 15:23:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:36 - IsConnectionValid True 15:23:36 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:24:10 - IsConnectionValid True 15:24:20 - IsConnectionValid True 15:24:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:24:25 - IsConnectionValid True 15:24:25 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:25:19 - IsConnectionValid True 15:25:25 - IsConnectionValid True 15:25:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:25:28 - IsConnectionValid True 15:25:28 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:26:09 - IsConnectionValid True 15:26:22 - IsConnectionValid True 15:26:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:27 - IsConnectionValid True 15:26:27 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:26:33 - IsConnectionValid True 15:26:33 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:26:52 - IsConnectionValid True 15:26:52 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:27:09 - IsConnectionValid True 15:27:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:27:23 - IsConnectionValid True 15:27:23 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:28:48 - IsConnectionValid True 15:28:48 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:32:13 - IsConnectionValid True 15:32:21 - IsConnectionValid True 15:32:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:32:26 - IsConnectionValid True 15:32:26 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:32:35 - IsConnectionValid True 15:32:35 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:32:44 - IsConnectionValid True 15:32:44 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:35:41 - IsConnectionValid True 15:35:48 - IsConnectionValid True 15:35:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:35:56 - IsConnectionValid True 15:35:56 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:36:01 - IsConnectionValid True 15:36:01 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:36:07 - IsConnectionValid True 15:36:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:36:43 - IsConnectionValid True 15:36:50 - IsConnectionValid True 15:36:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:36:55 - IsConnectionValid True 15:36:55 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:06 - IsConnectionValid True 15:37:06 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:07 - IsConnectionValid True 15:37:07 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:08 - IsConnectionValid True 15:37:08 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:09 - IsConnectionValid True 15:37:09 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:10 - IsConnectionValid True 15:37:10 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:11 - IsConnectionValid True 15:37:11 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:12 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:13 - IsConnectionValid True 15:37:13 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:14 - IsConnectionValid True 15:37:14 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:15 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:15 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:16 - IsConnectionValid True 15:37:16 - SELECT DISTINCT * FROM acc001 WHERE ACNO =0 Query 15:37:49 - IsConnectionValid True 15:37:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:38:13 - IsConnectionValid True 16:03:09 - IsConnectionValid True 16:03:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:03:12 - IsConnectionValid True 16:03:12 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 16:07:09 - IsConnectionValid True 16:07:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:07:15 - IsConnectionValid True 16:07:15 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 16:39:39 - IsConnectionValid True 17:09:05 - IsConnectionValid True 17:09:15 - IsConnectionValid True 17:09:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:18 - IsConnectionValid True 17:09:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:10:15 - IsConnectionValid True 17:10:32 - IsConnectionValid True 17:10:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:10:35 - IsConnectionValid True 17:10:35 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:14:55 - IsConnectionValid True 17:15:07 - IsConnectionValid True 17:15:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:15:09 - IsConnectionValid True 17:15:09 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:18:07 - IsConnectionValid True 17:18:13 - IsConnectionValid True 17:18:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:18:16 - IsConnectionValid True 17:18:16 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:20:29 - IsConnectionValid True 17:20:37 - IsConnectionValid True 17:20:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:20:39 - IsConnectionValid True 17:20:39 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:21:41 - IsConnectionValid True 17:21:41 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:21:52 - IsConnectionValid True 17:21:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:21:54 - IsConnectionValid True 17:21:54 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:22:10 - IsConnectionValid True 17:22:19 - IsConnectionValid True 17:22:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:22:21 - IsConnectionValid True 17:22:21 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:22:50 - IsConnectionValid True 17:22:50 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 17:22:58 - IsConnectionValid True 17:22:58 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:22:59 - IsConnectionValid True 17:22:59 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query