--Actualizar version de formatos
UPDATE    Formtos   set Version='10' where IdFmto= '1001'
UPDATE    Formtos   set Version='9' where IdFmto= '1007'
UPDATE    Formtos   set Version='2' where IdFmto= '1014'
UPDATE    Formtos   set Version='10' where IdFmto= '1056'
UPDATE    Formtos   set Version='2' where IdFmto= '2276'
Go
--Modificar nombre formato 2276
UPDATE    Formtos   set Formto='INFORMACIÓN DE RENTAS DE TRABAJO Y PENSIONES' where IdFmto= '2276'

--Inactivar formatos
UPDATE    Formtos   set Inactivo=1 where IdFmto IN ('1008','1016','1017','1018','1027','1043','1045','1046','1048','1049','1050','1051','1052','1054','1055','1585','1586','1587','1588','2278')
Go

--Inhabilitar conceptos 
Update Conceptos set inactivo = 1 where IDFMTO = '1001' and idconcepto IN ('5001',	'5018',	'5020',	'5022',	'5036',	'5037',	'5038',	'5039',	'5040',	'5041',	'5042',	'5047',	'5048',	'5049',	'5050',	'5051',	'5052',	'5053',	'5054',	'5057',	'8301',	'8302',	'8304',	'1105',	'1401',	'1402',	'1403',	'1404',	'1405',	'1406',	'1407',	'1408',	'1409',	'1410',	'1411',	'1412',	'1413',	'1501',	'1502',	'1503',	'1504',	'1505',	'1510',	'1511',	'1512',	'1513',	'1514',	'1515',	'1516',	'1517',	'1518',	'8004',	'8012',	'8013',	'8018',	'8020',	'8021',	'8024',	'8027',	'8102',	'8103',	'8105',	'8110',	'8111',	'8115',	'8116',	'8117',	'8118',	'8124',	'8126',	'8128',	'8129',	'8136',	'8137',	'8138',	'8203',	'8204',	'8206',	'8214',	'8220',	'8221',	'8226',	'8232',	'8251',	'8252',	'8258',	'8262',	'4040')
Update Conceptos set inactivo = 1 where IDFMTO = '1004' and idconcepto IN ('8301', '8302', '8304')
Update Conceptos set inactivo = 1 where IDFMTO = '1011' and idconcepto IN ('1105',	'1401',	'1402',	'1403',	'1404',	'1405',	'1406',	'1407',	'1408',	'1409',	'1410',	'1411',	'1412',	'1413',	'1501',	'1502',	'1503',	'1504',	'1505',	'1510',	'1511',	'1512',	'1513',	'1514',	'1515',	'1516',	'1517',	'1518',	'8004',	'8012',	'8013',	'8018',	'8020',	'8021',	'8024',	'8027',	'8102',	'8103',	'8105',	'8110',	'8111',	'8115',	'8116',	'8117',	'8118',	'8124',	'8126',	'8128',	'8129',	'8136',	'8137',	'8138',	'8203',	'8204',	'8206',	'8214',	'8220',	'8221',	'8226',	'8232',	'8251',	'8252',	'8258',	'8262')
Go