use cmsql
go
insert into cmins values ('NYUPMCARE', 'Upstate New York Medicare','medicare')


 
insert into insoverrides
select 'NYUPMCARE',tag, value from insoverrides where ins = 'EMPMCARE'

update insoverrides set value = '13282' where value = '13202' and ins = 'NYUPMCARE'

update insoverrides set value = 'NYUPMCARE' where   ins = 'NYUPMCARE' and tag = 'insdir'

insert into validvalues values ('INPFILE','UPSTATE_MEDICARE.INP','UPSTATE_MEDICARE.INP')

insert into validvalues values ('INSDIR','UPMCARE','Upstate Medicare')

