Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-12-05 : 19:47:45
|
| good evening:i have a huge table tin sql 2000 and it has 1148052581when 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 <= 20091231Arithmetic overflow error converting expression to data type datetime. how can i handle this error and execute the query without any eroor? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-12-05 : 20:02:39
|
where FEC_ACTUALIZACION >= '20090201' and FEC_ACTUALIZACION <= '20091231'Your dates need to be in strings like above.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Arithmetic overflow error converting expression to