EXEC SP_RPT_NOGR03_1 '01-0000047' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'NOGR03' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'NOGR03' ORDER BY Fr_ID EXEC SP_RPT_NOGR03_2 '01-0000047' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Horizontal, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'NOGR03' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'JMONTIEL' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'NOGR03' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_USUARIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_SSL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_AUTENTICACION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_PASSWORD' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_FROM' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_NOMBRE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_USUARIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_TIME_OUT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_PUERTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_SERVIDOR' SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL21' SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL21' SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = 'PL21' SELECT Empresa.Em_Razon_Social, Nomina_Configuracion.Nc_Plantilla_Email as Sc_Plantilla_Mail_CFD, Nomina_Configuracion.Nc_Formato_Impresion as Recibo, Sucursal.Sc_Bcc_Mail_CFD, Nomina.Nm_Folio as FolioDoc, Nomina.Nm_Folio as Folio, Empleado.Em_Cve_Empleado, Nomina_Caratula.Sc_Cve_Sucursal, (Empleado.Em_Nombre + ' ' + Empleado.Em_Apellido_Paterno + ' ' + Empleado.Em_Apellido_Materno) as Cl_Contacto_2, Empleado.Em_Email as Cl_Email_Contacto_2, '' as Cl_Contacto_1, '' as Cl_Email_Contacto_1, Sucursal.Sc_Formato_Comprobante_Pago, Comprobante_Digital.Cd_Tipo_Comprobante, (SELECT Comprobante_Digital.Cd_XML FROM Comprobante_Digital WHERE Cd_Documento = Nomina.Nm_Folio AND Cd_Tabla = 'NOMINA')AS Cd_XML , '' as Vn_Email, '' as Vn_Email_Contacto FROM Nomina INNER JOIN Empleado ON Empleado.Em_Cve_Empleado = Nomina.Em_Cve_Empleado INNER JOIN Nomina_Caratula ON Nomina_Caratula.Nmc_Folio = Nomina.Nmc_Folio INNER JOIN Nomina_Configuracion ON Nomina_Configuracion.Nc_Cve_Nomina_Configuracion = Nomina_Caratula.Nc_Cve_Nomina_Configuracion INNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal = Nomina_Caratula.Sc_Cve_Sucursal INNER JOIN Empresa ON Empresa.Em_Cve_Empresa = Sucursal.Em_Cve_Empresa INNER JOIN Comprobante_Digital ON Comprobante_Digital.Cd_Tabla = 'NOMINA' AND Comprobante_Digital.Cd_Documento = Nomina.Nm_Folio WHERE Nomina.Nm_Folio IN ('01-0000047') GROUP BY Empresa.Em_Razon_Social, Sucursal.Sc_Plantilla_Mail_CFD, Sucursal.Sc_Bcc_Mail_CFD, Nomina.Nm_Folio, Nomina.Nm_Folio, Empleado.Em_Cve_Empleado, Nomina_Caratula.Sc_Cve_Sucursal, Empleado.Em_Nombre, Empleado.Em_Apellido_Paterno, Empleado.Em_Apellido_Materno, Empleado.Em_Email, Sucursal.Sc_Formato_Comprobante_Pago, Comprobante_Digital.Cd_Tipo_Comprobante, Nomina_Configuracion.Nc_Plantilla_Email, Nomina_Configuracion.Nc_Formato_Impresion SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_DIRECTORIO_TEMPORAL_CFD_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ENVIAR_AUTOMATICAMENTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_ENVIO_CFD_HTML' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FAC_EXPORTAR_FACTURA_AUTOMATICAMENTE' SELECT Cd_XML FROM Comprobante_Digital WHERE Cd_Tabla = 'NOMINA' AND Cd_Documento = '01-0000047' INSERT INTO Comprobante_Digital( Cd_Tabla, Cd_Documento, Cd_Numero_Serie_Certificado, Cd_Numero_Aprobacion, Cd_Anio_Aprobacion, Cd_Cadena_Original, Cd_Sello_Digital, Cd_XML, Cd_Timbre_Sello_CFDI, Cd_Timbre_Sello_SAT, Cd_Timbre_Cadena_Original, Cd_Timbre_Fecha, Cd_Timbre_UUID, Cd_Timbre_CertificadoSAT, Cd_Timbre_RcfProvCertif, Cd_Timbre_Leyenda, Cd_Tipo_Comprobante, Cd_Metodo_Pago, Cd_Lugar_Expedicion, Cd_Numero_Cuenta_Pago, Cd_RFC_Emisor, Cd_RFC_Receptor, Cd_Monto, Cd_Serie, Cd_Serie_Folio, Cd_Factura, Cd_Tax_Id, Cd_Moneda, Cd_Tipo_Cambio, Cd_Forma_Pago, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif, Es_Cve_EStado ) VALUES ('NOMINA', '01-0000047', '00001000000407920058', 0, '', '||3.3|NM|42|2017-12-20T15:29:57|99|00001000000407920058|1275.00|0.00|MXN|1275.00|N|PUE|97127|ARP1312042C9|ARPEN SPR DE RL DE CV|601|HUCA970830JX5|ANGEL FRANCISCO HUITZIL CRUZ|P01|84111505|1|ACT|Pago de nómina|1275.00|1275.00|0.00|1.2|E|2017-12-15|2017-12-15|2017-12-15|1|1275.00|G6283217106|HUCA970830HYNTRN00|60159773633|2015-12-01|P106W|01|No|01|02|0000000004|ADMINISTRACION|AUXILIAR ADMINISTRATIVO|4|99|85.00|88.96|YUC|1275.00|0.00|0.00|0.00|1275.00|002|0097|AGUINALDO|0.00|1275.00||', 'WPNxF8R4I/yQbt+J2b2BRhEkmJN10GsOIgC7p4WBFhN8Ro3cBsbgn98Blcb4Mo3oM9KfRuvLzgvnsgjCm2Aq6/xiDgTRb+aYSahK2PdqhDZn4Pf6H7eL/UHlO0Kd6KSOTymcK1obecki6eLgNZGkpbM9CVReryeQt6xi4YUs9fDmE525TYm4Iv3BLWwiqbuVnQSzM5q1kgUzqd0O/hf5DN+sogB/K2cHy3/SJ0izpPO9bAc9vQBVgCYJSfy7S8mhiz+3t48bUMJjD/smUoYqOkV7kxDZ3/gZsF4m/RqOj7kHnhVfpLgxM8n0h3xZ9hTeuHlr7ZZVJO/hMyZlW5OXBA==', ' ','DTS/BLN52k+Jy5yWaMqCNhVBJAS8I+ApuHyU155IGtmDUwIT2h+NLK2LxZb6/mmIw03nB6G02LJHjEJ5AU+VIXTwTBQQJZYPu17WHuXUWZh+W38ocxRtFLWYX8e9zBD+lbBj/qXsJXqkU8CnItQUZ+XWnOfeikG5gemiXvvYvV2erPt4qXfhCqmuN8RNkNQERKJkCBbQYLRBDI90XjIpBLvqYSjNFdMA1yypH4F4uopsRKXpN3NKtfQ08J76Nu6aLVX48Vb5Ddo3HbbHA+x0S/9xGWm8frq4McPi2RHvjGGTA4UOHABbIOQd6+PA/UzgCqDrHsa9X7jvC61/bu9NvA==', 'twPKp3RWQMChIwPxIDp9EXe9qiCREYLznVSrpHuMZ5Egpokmqf766znmB8N9xyuhYo5O9f4Wir8Zb165UktEool0XXgcpKBO/aEn9QR+Vl8F6yN2FzCNTA+/nH4dCIV3f0+0W+QY4QljjY7mTFaAGaXXqMVGe8zhsM0EWZvcjKaShx2M1jdHcoB/Fddonc2h/TQFfWAhahutEWYt17326MfJETv1nPV85N8BmI7A24OGRACSMCcJj/YUMibYrlSvFRoxQ9FpMet7PtYMwmCGAxDQpb5kS4AG65U6I1lxqbYPSU/QpWaGzcFF7zs5u6eV5mD01GGOGIUR3kXp3B9RXQ==', '||1.1|0D1EA9AB-D26E-8F0B-0B5E-070B2CA2D5BF|2017-12-20T15:32:36|SAD110722MQA|WPNxF8R4I/yQbt+J2b2BRhEkmJN10GsOIgC7p4WBFhN8Ro3cBsbgn98Blcb4Mo3oM9KfRuvLzgvnsgjCm2Aq6/xiDgTRb+aYSahK2PdqhDZn4Pf6H7eL/UHlO0Kd6KSOTymcK1obecki6eLgNZGkpbM9CVReryeQt6xi4YUs9fDmE525TYm4Iv3BLWwiqbuVnQSzM5q1kgUzqd0O/hf5DN+sogB/K2cHy3/SJ0izpPO9bAc9vQBVgCYJSfy7S8mhiz+3t48bUMJjD/smUoYqOkV7kxDZ3/gZsF4m/RqOj7kHnhVfpLgxM8n0h3xZ9hTeuHlr7ZZVJO/hMyZlW5OXBA==|00001000000402636111||', '2017-12-20 15:32:36', '0D1EA9AB-D26E-8F0B-0B5E-070B2CA2D5BF', '00001000000402636111', 'SAD110722MQA', '', '04', '99','97127','','ARP1312042C9','HUCA970830JX5',1275, 'NM', '42', '', '', 'MXN', '0', '', 'JMONTIEL', '2017-12-20 15:32:37', 'JMONTIEL', '2017-12-20 15:32:37', 'AC' ) SELECT GetDate() as Fecha SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'NOMINA' AND Clave = '01-0000047' AND Id = '0000' INSERT INTO Imagen_Objeto( Objeto, Id, Clave, Imagen ,Modificado ) VALUES ( 'NOMINA', '0000', '01-0000047', null ,'2017-12-20 15:32:36' ) SELECT GetDate() as Fecha DELETE FROM Imagen_Objeto WHERE Objeto = 'NOMINA' AND Clave = '01-0000047' AND Id = '0000' SELECT NULL AS COL FROM sysobjects ob INNER JOIN syscolumns co ON ob.id = co.id WHERE ob.NAME = 'Imagen_Objeto' AND co.NAME = 'Modificado' SELECT NULL AS COL FROM sysobjects ob INNER JOIN syscolumns co ON ob.id = co.id WHERE ob.NAME = 'Imagen_Objeto' AND co.NAME = 'Id' SELECT ' <?xml version="1.0" encoding="utf-8"?><cfdi:Comprobante xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:nomina12="http://www.sat.gob.mx/nomina12" xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv33.xsd http://www.sat.gob.mx/nomina12 http://www.sat.gob.mx/sitio_internet/cfd/nomina/nomina12.xsd" Version="3.3" Serie="NM" Folio="42" Fecha="2017-12-20T15:29:57" Sello="WPNxF8R4I/yQbt+J2b2BRhEkmJN10GsOIgC7p4WBFhN8Ro3cBsbgn98Blcb4Mo3oM9KfRuvLzgvnsgjCm2Aq6/xiDgTRb+aYSahK2PdqhDZn4Pf6H7eL/UHlO0Kd6KSOTymcK1obecki6eLgNZGkpbM9CVReryeQt6xi4YUs9fDmE525TYm4Iv3BLWwiqbuVnQSzM5q1kgUzqd0O/hf5DN+sogB/K2cHy3/SJ0izpPO9bAc9vQBVgCYJSfy7S8mhiz+3t48bUMJjD/smUoYqOkV7kxDZ3/gZsF4m/RqOj7kHnhVfpLgxM8n0h3xZ9hTeuHlr7ZZVJO/hMyZlW5OXBA==" FormaPago="99" NoCertificado="00001000000407920058" Certificado="MIIGFzCCA/+gAwIBAgIUMDAwMDEwMDAwMDA0MDc5MjAwNTgwDQYJKoZIhvcNAQELBQAwggGyMTgwNgYDVQQDDC9BLkMuIGRlbCBTZXJ2aWNpbyBkZSBBZG1pbmlzdHJhY2nDs24gVHJpYnV0YXJpYTEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3RyYWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBTZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMR8wHQYJKoZIhvcNAQkBFhBhY29kc0BzYXQuZ29iLm14MSYwJAYDVQQJDB1Bdi4gSGlkYWxnbyA3NywgQ29sLiBHdWVycmVybzEOMAwGA1UEEQwFMDYzMDAxCzAJBgNVBAYTAk1YMRkwFwYDVQQIDBBEaXN0cml0byBGZWRlcmFsMRQwEgYDVQQHDAtDdWF1aHTDqW1vYzEVMBMGA1UELRMMU0FUOTcwNzAxTk4zMV0wWwYJKoZIhvcNAQkCDE5SZXNwb25zYWJsZTogQWRtaW5pc3RyYWNpw7NuIENlbnRyYWwgZGUgU2VydmljaW9zIFRyaWJ1dGFyaW9zIGFsIENvbnRyaWJ1eWVudGUwHhcNMTcxMDI1MjIzMjQ0WhcNMjExMDI1MjIzMjQ0WjCBtzEeMBwGA1UEAxMVQVJQRU4gU1BSIERFIFJMIERFIENWMR4wHAYDVQQpExVBUlBFTiBTUFIgREUgUkwgREUgQ1YxHjAcBgNVBAoTFUFSUEVOIFNQUiBERSBSTCBERSBDVjElMCMGA1UELRMcQVJQMTMxMjA0MkM5IC8gUEVTQTY5MDIxOU5VODEeMBwGA1UEBRMVIC8gUEVTQTY5MDIxOUhZTk5MUjA0MQ4wDAYDVQQLEwVVTklDQTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAJ7wrWbkxwyeGpkSbIJfSxBKOsTSz2ODvRkx0hjYtN36DqLz0SBctqOFoRTny0RX3Gu17AoW1tHdzZsfktCiZPX1niSx5gs5YhP0BVoP+9cEidbCkcEo2uq/teRwd7p3K/gLeaz3DG1IJ+xBhaRrnRm8gtnHLafLua9/qzfUzV+oDzDjFTLlRsWVY+yqIdEAoaarEAesfzDnD9CcIqsUESpb0EvbY1QqBipQBSGtAF/7/PoJFOp2waOBdMIFH3mu+6nFFqZ5uwrMzyRffxk7EUs3MkAmUEPG1I1hJXQyj2Tfu7yV8RgAw9KWxTNxOGpG1qi9IGBD6grxRtprDLdFvOUCAwEAAaMdMBswDAYDVR0TAQH/BAIwADALBgNVHQ8EBAMCBsAwDQYJKoZIhvcNAQELBQADggIBAAc8MQRsEqT3QVys5Ce1BG7HAFoT5RPbVukHiDvuUXCvuOZ61l9DY2m00NLtyK2VQ6vOyrQ/xC26KuO247DdbV6tian8IPkrAfWSGGCX3/wrkFVsc6V/W6bRSzOrSIPMxoWGjCfe26ep+SwaSrAgx7WSm31EPBf3tEpeuAos7kykm8clKDpt1d2j32iJlYyqTdzldHHmTTkMtW7RVpyqdszxDLXgfYNqHgw62cARwgkRce3mdRaKLAy6N86DED8Chj3Hjb3EqC6lVTLOP+9ESjjHwsUw5rjf465tBH+dYAcSL/W6bc+hXeNJhvlCPN/wRfdepTWjCILZWzZYr0cZACk1Xodl7AVxhsaVDVN9J8Ssd/hmJfqadClygM2eRwEbHoxjWr6aIAEtFcRsk4fNld4GCYhE3aRHZmDCqAk64ayFPJgKxdB5fl0Azrm3iXRt9SfJNXVD8vDKZ0br+xhi+IRHCRnm4xlQCqZHiy2SXhH9GRPPxqST22VNod/tuKkRzuN0pTE0RJ85q1fhOhxhSgzTih6jj+BUwm+Xc/Vfu8tT3dL24MIr5ibH7kvy5NCGoMHgF3R9K7RQua8aFuZqFLuXWqrWjIJS0b0S21DueH4S9d7rbHwJIie9uPbWTkvyq6lXkqgOCbc9W52yg7BMfhCFP6c29RKNW9nRVQqkUDld" SubTotal="1275.00" Descuento="0.00" Moneda="MXN" Total="1275.00" TipoDeComprobante="N" MetodoPago="PUE" LugarExpedicion="97127"><cfdi:Emisor Rfc="ARP1312042C9" Nombre="ARPEN SPR DE RL DE CV" RegimenFiscal="601"/><cfdi:Receptor Rfc="HUCA970830JX5" Nombre="ANGEL FRANCISCO HUITZIL CRUZ" UsoCFDI="P01"/><cfdi:Conceptos><cfdi:Concepto ClaveProdServ="84111505" Cantidad="1" ClaveUnidad="ACT" Descripcion="Pago de nómina" ValorUnitario="1275.00" Importe="1275.00" Descuento="0.00"/></cfdi:Conceptos><cfdi:Complemento><nomina12:Nomina Version="1.2" TipoNomina="E" FechaPago="2017-12-15" FechaInicialPago="2017-12-15" FechaFinalPago="2017-12-15" NumDiasPagados="1" TotalPercepciones="1275.00"><nomina12:Emisor RegistroPatronal="G6283217106"/><nomina12:Receptor Curp="HUCA970830HYNTRN00" NumSeguridadSocial="60159773633" FechaInicioRelLaboral="2015-12-01" Antigüedad="P106W" TipoContrato="01" Sindicalizado="No" TipoJornada="01" TipoRegimen="02" NumEmpleado="0000000004" Departamento="ADMINISTRACION" Puesto="AUXILIAR ADMINISTRATIVO" RiesgoPuesto="4" PeriodicidadPago="99" SalarioBaseCotApor="85.00" SalarioDiarioIntegrado="88.96" ClaveEntFed="YUC"/><nomina12:Percepciones TotalSueldos="1275.00" TotalSeparacionIndemnizacion="0.00" TotalJubilacionPensionRetiro="0.00" TotalGravado="0.00" TotalExento="1275.00"><nomina12:Percepcion TipoPercepcion="002" Clave="0097" Concepto="AGUINALDO" ImporteGravado="0.00" ImporteExento="1275.00"/></nomina12:Percepciones></nomina12:Nomina></cfdi:Complemento></cfdi:Comprobante> Arpe 1301 ' SELECT '' AS XML SELECT St_ID, St_Servidor, St_Url, St_Url_33, St_Soap_Envio, St_Soap_Envio_Test, St_Namespace, Es_Cve_Estado FROM EMPRESAS..Servidor_Timbrado WHERE St_Ping >= 0 AND Es_Cve_Estado <> 'BA' ORDER BY St_Ping ASC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL' EXEC sp_Get_Incapacidades '01-0000047' SELECT TOP 1 Nomina_Concepto.Nc_CodigoFROM Nomina INNER JOIN Nomina_Concepto ON Nomina.Nc_Cve_Nomina_Concepto = Nomina_Concepto.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000047' AND Nomina_Concepto.Nc_Tipo = '0001' AND Nomina_Concepto.Nc_Otro_Pago = 'SI' SELECT CASE X.TOTALIMPUESTORETENIDO WHEN 0 THEN '' ELSE CAST(X.TOTALIMPUESTORETENIDO AS NVARCHAR(50)) END AS TOTALIMPUESTORETENIDO, CASE X.TOTALOTRASRETENCIONES WHEN 0 THEN '' ELSE CAST(X.TOTALOTRASRETENCIONES AS NVARCHAR(50)) END AS TOTALOTRASRETENCIONESFROM (SELECT ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN 0 ELSE ROUND(Nomina.Nm_Importe,2) END), 0) AS TOTALOTRASRETENCIONES, ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN ROUND(Nomina.Nm_Importe,2) ELSE 0 END), 0) AS TOTALIMPUESTORETENIDOFROM Nomina INNER JOIN Nomina_Concepto ON Nomina_Concepto.Nc_Cve_Nomina_Concepto = Nomina.Nc_Cve_Nomina_Concepto WHERE Nomina.Nm_Folio = '01-0000047' AND dbo.Nomina_Concepto.Nc_Tipo = '0002'HAVING ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN 0 ELSE Nomina.Nm_Importe END), 0) <> 0 OR ISNULL(SUM(CASE Nomina_Concepto.Nc_Codigo WHEN '002' THEN Nomina.Nm_Importe ELSE 0 END), 0) <> 0) AS X SELECT ''WHERE 1 = 0 SELECT ''WHERE 1 = 0