I have two table with a PK ID but one table has a padding 13 digits.
Table1 PK 1234567890000
Table2 PK 123456789
What's the best approach when joining? I have the below join but get an error
The conversion of the varchar value '7324004373918' overflowed an int column.
LEFT JOIN Summary C ON RIGHT('0000000000000',B.Id) = RIGHT('0000000000000',C.id )