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 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...

Vote count: 0 I am accessing an Azure Database via MS SQL Server 2014 Management Studio. I do not own the Azure database that I am coecting to. I have coected to this database in the past (with occasional difficulties) but for some reason when I now use the Coect to Server I get the following error: The odd thing is that IP referred to in the error message is my router's IP address as opposed to the IP addressed assigned to me (I checked my IP address using ipchicken(IPCHICKEN). Does anyone know what is happening? asked 28 secs agouser918967 Let's block ads! بخوانید...