I have table T1 with fields T1.ID, T1.CheckBoxCol
The T2 tabel has the same ID as T2.ID and T2.CheckBox1, T2.CheckBox2, T2. CheckBox3
Now, I need to check T1 and
if T1.CheckBoxCol=1 then set T2.CheckBox1=1
else if T1.CheckBoxCol=2 then set T2.CheckBox2=1
else if T1.CheckBoxCol=3 then set T2.CheckBox3=1
for each T1.ID
How can I do this?
create Table T1 (ID int, C1 int)
create Table T2 (ID int, C1 int,c2 int,c3 int)
insert into T1 select 1 ,1
insert into T1 select 2 ,2
insert into T1 select 3 ,3
insert into T2 select 1 ,0,0,0
insert into T2 select 2 , 0,0,0
insert into T2 select 3 ,0, 0,0
Update T2 set c1= (select case when isnull((select C1 from T1 where T1.id=T2.id ),-1)=1 then 1 else 0 end), c2=(select case when isnull((select C1 from T1 where T1.id=T2.id ),-1)=2 then 1 else 0 end), c3=(select case when isnull((select C1 from T1 where T1.id=T2.id ),-1)=3 then 1 else 0 end)
regards
mobin
Hello,
try the following syntax....
update
Test2set
CheckBoxCol1 = Case T1.TIDwhen 1 then 1when 2 then 1when 3 then 1
when 4 then 1
else 0
end,
CheckBoxCol2
= Case T1.TIDwhen 1 then 1when 2 then 1when 3 then 1when 4 then 1else 0end,CheckBoxCol3
=Case T1.TIDwhen 1 then 1when 2 then 1when 3 then 1when 4 then 1else 0endfrom
Test1 T1 inner join Test2 T2ON
T1.TID = T2.TIDThanks....