Viewing 3 posts - 16 through 18 (of 18 total)
SELECT CAST(SUM(FileSize)AS INT) MB, CAST(SUM(FileSize)/1000 AS INT) GB
from o_file
where volid = 16 and groupid = 221
Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression...
October 7, 2004 at 9:28 am
#525781
Are you saying
CAST(SUM(FileSize)AS BIGINT) MB, CAST(SUM(FileSize)/1000 AS BIGINT) GB from o_file where volid = 16 and groupid = 221
Because I still get, "incorrect syntax near the keyword 'sum'"
October 6, 2004 at 5:00 pm
#525689
CAST(SUM(FileSize)) AS BIGINT) MB,
CAST(SUM(FileSize)/1000 AS BIGINT) GB
I get incorrect syntax near the keyword 'sum'
October 6, 2004 at 12:53 pm
#525633