insert 1 field into multiple fields 1

[puter55]

Table1 contains a integer field called type. It contains either a 1,2,3,4, or 5.

I need to insert into table2 either a 1 or 0 into 5 different fields. So if type contains 3 I would need to insert
field1 0
field2 0
field3 1
field4 0
field5 0

Thanks

 

[RyanEK]

Hi,

How about...

insert into [Table2] (field1, field2, field3, field4, field5)
select 
case when types = 1 then 1 else 0 end,
case when types = 2 then 1 else 0 end,
case when types = 3 then 1 else 0 end,
case when types = 4 then 1 else 0 end,
case when types = 5 then 1 else 0 end
from [Table1]

Ryan

 

[puter55]

I think that should work - thanks.