When I run this command with
SELECT COUNT(*) AS [Records], SUM(t.Amount) AS [Total] FROM dbo.t1 AS t WHERE t.Id > 0 AND t.Id < 101;
Arithmetic overflow error converting expression to data type int.
Any idea on what is the cause of it?
I'm just following the instructions in this answer.