i have a huge table tin sql 2000 and it has 1148052581
when i use select o select count_big(*) command it yields an error:
select count_big(*) from HECHOS_MOVTO_PREPAGO_ACTUACIONES
where FEC_ACTUALIZACION >= 20090201 and FEC_ACTUALIZACION <= 20091231
Arithmetic overflow error converting expression to data type datetime.
how can i handle this error and execute the query without any eroor?
id appreciate your help