update query= update hits set ct=ct+1 where convert(char(10),dt,110) = '02-22-2012' Hits