SQL Server 2012 Join with padded zeros

ساخت وبلاگ

Vote count: 0

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 )
asked 24 secs ago

back soft...
ما را در سایت back soft دنبال می کنید

برچسب : sql server 2012,sql server 2012 sp3,sql server 2012 management studio,sql server 2012 r2,sql server 2012 express edition,sql server 2012 versions,sql server 2012 developer edition,sql server 2012 native client,sql server 2012 sp2,sql server 2012 developer edition download, نویسنده : استخدام کار backsoft بازدید : 315 تاريخ : سه شنبه 20 مهر 1395 ساعت: 14:12