Xtykutl

I want to populate the column [ID contact] with the column [Référence]. Any clue on how to debug this query?

alter table [DB_Test].[dbo].[Check_Result]

add [ID contact] varchar(200)



update [DB_Test].[dbo].[Check_Result]

    set [ID contact] = (select [Référence]

                        from [DB_Test].[dbo].All_Contracts)

I get this Error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

The reason for the error is below query returns multiple [Référence] values.

select [Référence] from [DB_Test].[dbo].All_Contracts

You need to maintain a foreign key relationship between [dbo].[Check_Result] table and [dbo].All_Contracts

After that, you can Join the two tables and update the [ID Contact] from [Référence]

UPDATE C

SET C.[ID contact] = AC.[Référence]

FROM [DB_Test].[dbo].[Check_Result] C

INNER JOIN [DB_Test].[dbo].All_Contracts AC ON AC.FORIEGNKEY_COL = C.FORIEGNKEY_COL

I am assuming there is relationship between two table, if so then you can do JOIN :

UPDATE 

     cr.[ID contact] = cn.[Référence]

FROM [DB_Test].[dbo].[Check_Result] cr INNER JOIN

     [DB_Test].[dbo].All_Contracts cn

     ON cr.<col> = cn.<col>;