T-SQL SUM() Overflow?

2004-08-16 Thread David Mohorn
Hello, I'm trying to run a T-SQL query that will SUM a column of type INT. I'm, however, receiving the following error: Arithmetic overflow error converting expression to data type int. The four rows that its trying to sum have values of 3098082, 2488114, 316804, and 10657. What do I do? --

Database Stats

2004-08-16 Thread David Mohorn
I have about 25 databases that I need to run the same query against that returns about 5 columns of information. I need this information then published within an Excel spreedsheet. What is the best way do handle this? Currently, I'm running each query manually, copying/pasting the result to

RE: How Do I Do This In Version 3.23.56?

2003-12-31 Thread David Mohorn
Have you tried to execute this statement manually thru their PHPAdmin? Have you checked the case of your SQL? I recently migrated a bunch of PHP/MySQL code from a Linux to Windows then back to Linux and some of my SQL did not work because the case of the table names had been converted to part