I am sorry for that. Actually there is common column is there in two tables. Please check below

Table1:

PID ID1 ID2 ID3 ID4 ID5 ID6

1 NULL NULL NULL NULL NULL NULL

2 NULL NULL NULL NULL NULL NULL

3 NULL NULL NULL NULL NULL NULL

Table2:

PID ID Value

1 1 10

1 2 20

1 3 30

1 4 12

1 5 32

1 6 12

2 1 11

2 2 21

2 3 30

2 4 15

2 5 32

2 6 12

3 1 18

3 2 20

3 3 33

3 4 12

3 5 42

3 6 52

Now my query is:

update t1 set t1.ID1 = t2.value

from Table1 t1

inner join Table2 t on t1.PID = t2.PID AND t2.ID=1

update t1 set t1.ID2 = t2.value

from Table1 t1

inner join Table2 t on t1.PID = t2.PID AND t2.ID=2

.

.

.

.

Thanks in advance,

Vijay