select * from comesat where cam_sat='uni_sat' 

insert into comesat (CAM_SAT,CLA_SAT,DES_SAT,OB1_SAT,OB2_SAT,NOM_SAT,PAR_SAT)
values ('UNI_SAT','H87','Pieza','Pieza','Pieza','Unidades Productos/Servicios',' ')
insert into comesat (CAM_SAT,CLA_SAT,DES_SAT,OB1_SAT,OB2_SAT,NOM_SAT,PAR_SAT)
values ('UNI_SAT','E48','Servicio','Servicio','Servicio','Unidades Productos/Servicios',' ')
select * from cometda
select * from comemov where alm_tda='AS'

select * from comeisu where isnull(uni_sat,' ')=' ' or isnull(cls_sat,' ')=' '
update comeisu set cls_sat='01010101',uni_sat='H87',ubf_sat='U',fum_sat=1
where isnull(uni_sat,' ')=' ' or isnull(cls_sat,' ')=' '

select * from comeisu where isnull(uni_sat,' ')<>'H87'
update cometda set des_tda='Cobro y ajuste de cajas' where alm_tda='SC'

insert into cometda (alm_tda,des_tda,ubi_tda,ave_tda,alc_tda,cod_nom,mub_tda,usu_usu)
values ('SC','Cobro y ajuste de cajas',' ',1,0,' ',0,1)
