back soft

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 agoToby Let's block ads! بخوانید...

Vote count: 0 I am using remote desktop, logging directly onto the box that houses the sql instance, and trying to use debugging, however getting the dreaded unable to start t-sql debugging... error message. My colleague can take the same steps, same box, and using the same sql account and has no issue, the only difference is we are using our own windows accounts, which when checked both of us are part of the local admin group. we are both logging on as the instance name also. SSMS 2014. Any ideas? asked 42 secs agouser2808765 Let's block ads! بخوانید...

Vote count: 0 I have 2 tables 1 [dbo].[t_Olympic_Country] where i have all the county list but population and GDP is empty. Now i have second table which has most of the countries with population and GDP data but its it has not same number of data. I would like to enter value of GDP and population from 2nd temp table [dbo].[temptable1] to first [dbo].[t_Olympic_Country] in case the cuntry name matches with [dbo].[t_Olympic_Country]. I mean a conditional bulk update for [dbo].[t_Olympic_Country]. Can anybody help me? i tried following which gives error : INSERT INTO [dbo].[t_Olympic_Country]( [GDP] ) SELECT temp.[GDP] FROM [dbo].[temptable1] temp WHERE (temp.[Country_Name] IN (SELECT tl.[Coun...