No it is not static. The date was passed as @startdate but the CounterDateTime is read from table

(CONVERT(DATETIME, CONVERT(VARCHAR(24),@CounterDateTime)) >= CAST(@startDate AS DATETIME))

Today all I did varchar(16) instead varchar(24) and...

Hi

I have been trying to resolve the same indof problem.

Myy counterdatetime field is of char(24) the data stays as '2010-01-24 22:30:43:234'

All I am having

CONVERT(DATETIME, CONVERT(VARCHAR(24),CounterDateTime))>=CAST('1/19/2010 10:44:18 PM' AS...