update dm_organization set organization_type='03' where organization_id='311000'
go
update dm_organization set organization_type='02' where organization_id='300000'
go
update dm_organization set organization_type='04' where (organization_id <> '300000' and organization_id <> '311000') and ORGANIZATION_ID like '3%'
go
update dm_organization set organization_type='03' where organization_id='411000'
go
update dm_organization set organization_type='02' where organization_id='400000'
go
update dm_organization set organization_type='04' where (organization_id <> '400000' and organization_id <> '411000') and ORGANIZATION_ID like '4%'
go
update dm_organization set organization_type='03' where organization_id='511000'
go
update dm_organization set organization_type='02' where organization_id='500000'
go
update dm_organization set organization_type='04' where (organization_id <> '500000' and organization_id <> '511000') and ORGANIZATION_ID like '5%'
go
update dm_organization set organization_type='03' where organization_id='711000'
go
update dm_organization set organization_type='02' where organization_id='700000'
go
update dm_organization set organization_type='04' where (organization_id <> '700000' and organization_id <> '711000') and ORGANIZATION_ID like '7%'
go
update dm_organization set organization_type='03' where organization_id='811000'
go
update dm_organization set organization_type='02' where organization_id='800000'
go
update dm_organization set organization_type='04' where (organization_id <> '800000' and organization_id <> '811000') and ORGANIZATION_ID like '8%'
go