QUERY SQL
pass sa
ONC0608246N2#

CONSULTAR LOS CAMPOS DENTRO DE LAS TABLAS 

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'ZCONGER'
--Cambiar 'Product' por nombre de nuestra tabla



select ST,ENDOSO,* from CXPFAC where CIA = '1' and NUMCXP = '18255'

update CXPFAC set endoso = 'NORMA ANGELICA GUERRERO ROMO'
where CIA = '1' and NUMCXP = '18255'



selecT PLAVTA,* from zconger where fecon >= '01/02/2025' and fecon <= '28/02/2025' AND PLAVTA >= 'ESD' AND PLAVTA <= 'ESG'




ASIGNACION DE JARDIN PRESUPUESTO

SELECT * FROM ZPRESP1 WHERE FOLPRE = '129539'


UPDATE ZPRESP1 SET JARFIN = 'AJ'
  WHERE FOLPRE = '129539'


  UPDATE ZPRESP1 SET SECFIN = '4'
  WHERE FOLPRE = '129539'

  UPDATE ZPRESP1 SET LOTEFI = '221'
  WHERE FOLPRE = '129539'

  UPDATE ZPRESP1 SET JARDES = 'LA PEREGRINACION'
  WHERE FOLPRE = '129539'






select PLAVTA,FECON,* from ZCONGER
	INNER join ZHISPAG on ZCONGER.TIPO = ZHISPAG.TIPO and ZCONGER.CONT = ZHISPAG.CONT
	 AND ZCONGER.FECON >= '01/04/2025' AND ZCONGER.FECON <= '30/04/2025' 
		AND ZCONGER.PLAVTA >= 'ES2' AND ZCONGER.PLAVTA <= 'ES5'

	 select NOPAG,FECON,PLAVTA,* from ZCONGER
	INNER join ZHISPAG on ZCONGER.TIPO = ZHISPAG.TIPO and ZCONGER.CONT = ZHISPAG.CONT
	 AND ZCONGER.FECON >'01/02/2025' AND ZCONGER.FECON <= '28/02/2025' AND ZHISPAG.NOPAG > '59' AND ZCONGER.STATU <> ''lect 

	 select NOPAG,FECON,* from ZCONGER
	INNER join ZHISPAG on ZCONGER.TIPO = ZHISPAG.TIPO and ZCONGER.CONT = ZHISPAG.CONT
	 AND ZCONGER.FECON >'01/02/2025' AND ZCONGER.FECON <= '28/02/2025' AND ZHISPAG.NOPAG > '59' AND ZCONGER.STATU <> ''


select * from ZCONGER
INNER join ZCONDAT on ZCONGER.TIPO = ZCONDAT.TIPO and ZCONGER.CONT = ZCONDAT.CONT
inner join ZHISPAG on ZCONGER.tipo = ZHISPAG.tipo and ZCONGER.CONT = ZHISPAG.CONT
where ZCONGER.TIPO = 'p'
		and ZCONGER.CONT = 66642



ELIMANA COMENTARIOS DOMICILIADOS 
select CLASE,EXT,COMENT,* from ZCONGER where TIPO = '1' and CONT = '97579'"CAMBIAR TIPO Y CONTRATO"


update ZCONGER set CLASE = ''
 where TIPO = '1' and CONT = '97579' "CAMBIAR TIPO Y CONTRATO"

 update ZCONGER set EXT = ''
 where TIPO = '1' and CONT = '97579'  "CAMBIAR TIPO Y CONTRATO"

 update ZCONGER set COMENT = ''
 where TIPO = '1' and CONT = '97579' "CAMBIAR TIPO Y CONTRATO"

ELIMINAR CONTRATOS DE  BASE BANAMEX DOMICILIADOS 
SELECT * FROM BANAMEX WHERE TIPO = 'N' AND CONT = '1625'



DELETE BANAMEX WHERE TIPO = 'N' AND CONT = '1625'






actualizacion de fecha de pago en hispag

select * from ZHISPAG where TIPO = 'M' and CONT = '284'


update ZHISPAG set FECPAG = '22/10/2025'
  where TIPO = 'm' and CONT = '284' and NOPAG >= '53' AND NOPAG <= '141'

  
update ZHISPAG set LUGPAG = '1'
    where TIPO = 'm' and CONT = '284' and NOPAG >= '53' AND NOPAG <= '141'

  
update ZHISPAG set STATU = 'p'
   where TIPO = 'm' and CONT = '284' and NOPAG >= '53' AND NOPAG <= '141'



select FECON,MOTCA,* from ZCAREC
	INNER join Zconger on ZCarec.TIPO = ZCONGER.TIPO and Zcarec.CONT = Zconger.CONT




****QUITAR NULL***
UPDATE ZCONGER 
SET    MOTCA = ''
WHERE   TIPO = '1' AND CONT = '2'  AND MOTCA IS NULL
.
.

.

doble inner join


FROM ZPRESP1 
		INNER JOIN ZGUIA ON ZGUIA.FOLGUI = ZPRESP1.FOLGUI
		INNER JOIN ZCONDAT ON ZGUIA.TIPO = ZCONDAT.TIPO AND  ZGUIA.CONT = ZCONDAT.CONT
		WHERE ZPRESP1.FOLPRE = @FOLGUI
		GROUP BY ZPRESP1.NOMCLI
		, ZPRESP1.TIPO
		, ZPRESP1.CONT
		, ZPRESP1.FENACI
		, ZPRESP1.FEDEFU
		, ZPRESP1.FEINHU
		, ZPRESP1.HRIN
		, ZPRESP1.ORDINH
		, ZPRESP1.JARFIN
		, ZPRESP1.SECFIN
		, ZPRESP1.LOTEFI
		, ZPRESP1.JARDES
		, ZGUIA.NOMINH
		, ZPRESP1.DIGVER
		, ZGUIA.DIGVER
		, ZGUIA.FOLGUI
		, ZCONDAT.CLAFOS
		, ZGUIA.NOMCLI
		, ZGUIA.TIPO
		, ZGUIA.CONT

	SELECT COUNT(*) AS NU_REGISTROS
                FROM ZGUIA
                WHERE ZGUIA.FOLGUI = @FOLGUI


*****reporte miriam num srvicios******* sacar cada 15 dias
select * from zpresp1 where FECHA >= '01/10/2025' and fecha <= '15/10/2025'

ACTUALIZACION NMXISPT DANY

select * from NMXISPT

delete NMXISPT


INSERT INTO NMXISPT(TIPO,INFERIOR,SUPERIOR,CUOTA,PORCIENTO,SUBFIJO,SUBMARG,CUOTASUB,[PORC-SUB],VERSIO)
VALUES 
    ('S','0.01','194.46','0.00','1.92','109.00','0.01','0.00','0.00','1'),
    ('S','194.47','1650.67','3.71','6.40','109.00','194.47','0.00','0.00','1'),
	('S','1650.68','2342','96.95','10.88','109.00','1650.68','0.00','0.00','1'),
	('S','2342.01','2900.87','96.95','10.88','0.00','1650.68','0.00','0.00','1'),
	('S','2900.88','3372.11','232.96','16.00','0.00','2900.88','0.00','0.00','1'),
	('S','3372.12','4037.32','308.35','17.92','0.00','3372.12','0.00','0.00','1'),
	('S','4037.33','8142.75','427.56','21.36','0.00','4037.33','0.00','0.00','1'),
	('S','8142.76','12834.08','1304.45','23.52','0.00','8142.76','0.00','0.00','1'),
	('S','12834.09','24502.45','2407.86','30.00','0.00','12834.09','0.00','0.00','1'),
    ('S','24502.46','32669.91','5908.35','32.00','0.00','24502.46','0.00','0.00','1'),
	('S','32669.92','98009.66','8521.94','34.00','0.00','32669.92','0.00','0.00','1'),
	('S','98009.67','99999999.00','30737.49','35.00','0.00','98009.67','0.00','0.00','1'),
	('Q','0.01','416.70','0.00','1.92','237.50','0.01','0.00','0.00','2'),
    ('Q','416.71','3537.15','7.95','6.40','237.50','416.71','0.00','0.00','2'),
	('Q','3537.16','5085.50','207.75','10.88','237.50','3537.16','0.00','0.00','2'),
	('Q','5085.51','6216.15','207.75','10.88','0.00','3537.16','0.00','0.00','2'),
	('Q','6216.16','7225.95','499.20','16.00','0.00','6216.16','0.00','0.00','2'),
	('Q','7225.96','8651.40','660.75','17.92','0.00','7225.96','0.00','0.00','2'),
	('Q','8651.41','17448.75','916.20','21.36','0.00','8651.41','0.00','0.00','2'),
	('Q','17448.76','27501.60','2795.25','23.52','0.00','17448.76','0.00','0.00','2'),
	('Q','27501.61','52505.25','5159.70','30.00','0.00','27501.61','0.00','0.00','2'),
    ('Q','52505.26','70006.95','12660.75','32.00','0.00','52505.26','0.00','0.00','2'),
	('Q','70006.96','210020.70.','18261.30','34.00','0.00','70006.96','0.00','0.00','2'),
	('Q','210020.71','99999999.00','65866.05','35.00','0.00','210020.71','0.00','0.00','2'),
	('M','0.01','844.59','0.00','1.92','475.00','0.01','0.00','0.00','3'),
    ('M','844.60','7168.51','16.22','6.40','475.00','844.60','0.00','0.00','3'),
	('M','7168.52','10171.00','420.95','10.88','475.00','7168.52','0.00','0.00','3'),
	('M','10171.01','12598.02','420.95','10.88','0.00','7168.52','0.00','0.00','3'),
	('M','12598.03','14644.64','1011.68','16.00','0.00','12598.03','0.00','0.00','3'),
	('M','14644.65','17533.64','1339.14','17.92','0.00','14644.65','0.00','0.00','3'),
	('M','17533.65','35362.83','1856.84','21.36','0.00','17533.65','0.00','0.00','3'),
	('M','35362.84','55736.68','5665.16','23.52','0.00','35362.84','0.00','0.00','3'),
	('M','55736.69','106410.50','10457.09','30.00','0.00','55736.69','0.00','0.00','3'),
    ('M','106410.51','141880.66','25659.23','32.00','0.00','106410.51','0.00','0.00','3'),
	('M','141880.67','425641.99.','37009.69','34.00','0.00','141880.67','0.00','0.00','3'),
	('M','425642.00','99999999.00','133488.54','35.00','0.00','425642.00','0.00','0.00','3')