(((FromTime BETWEEN DATEADD(hh, DATEDIFF(hh, 0,
DATEADD(hh, DATEDIFF(hh, 0,
or
(FromTime <= DATEADD(hh, DATEDIFF(hh, 0,
ToTime >= DATEADD(hh, DATEDIFF(hh, 0,
)
or
(ToTime BETWEEN DATEADD(hh, DATEDIFF(hh, 0,
DATEADD(hh, DATEDIFF(hh, 0,
or
(FromTime <= DATEADD(hh, DATEDIFF(hh, 0,
and ToTime >= DATEADD(hh, DATEDIFF(hh, 0,
))
AND
(( (FromTime BeTween DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
or
FromTime <= DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
ToTime >= DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
)
or
(ToTime between DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
or
FromTime <= DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
ToTime >= DATEADD(MINUTE, DATEDIFF(MINUTE, 0,
) ))
and ETC.EmployeeID=71 and ETC.ClientID=20
order by ETC.TCID desc