Consider the following MS SQL query:
DECLARE @po_length as bigint
SET @po_length = 12192000001;
Round(Left(@po_length,(len(@po_length)-6)) / 304.8,0);
It generates this error:
Msg 8115, Level 16, State 8, Line 4
Arithmetic overflow error converting varchar to data type numeric.
And I am at a loss at to why. Anyone?