Hello
I am checking that all records in 16 tables are same.
It was all running well till 2 records added today and it begins to give error.
Procedure :
declare @t table (branch varchar(30) , checksumvalue bigint )
insert @t (branch, checksumvalue)
select branch=(select abbr from payfd53_sql.dbo.company)
, checksumvalue=sum(BINARY_CHECKSUM(card_code))
from payfd53_sql.dbo.am_blacklistEmployee
insert @t (branch, checksumvalue)
select branch=(select abbr from payfgrmn_sql.dbo.company)
, checksumvalue=sum(BINARY_CHECKSUM(card_code))
from payfgrmn_sql.dbo.am_blacklistEmployee
Error:
Arithmetic overflow error converting expression to data type int
What is the workaround?