I have a SQL database and performing the following SQL statement:<BR><BR>SELECT Sum(DateDiff(second,act_dt, status_dt)) AS duration<BR>FROM activity<BR><BR>and I receive the following error:<BR><BR>Arithmetic overflow error for type int, value = 2070853<BR><BR>Can someone help me?? I think this is storing as an interger and I may need to convert it to a longinteger value or equivelant in SQL as longinteger. How would you do the convert in the select statement or is there any other solutions?