SELECT Nomina_Configuracion.Es_Cve_Estado, Nomina_Configuracion.Nc_Tipo_Nomina, Nomina_Configuracion_Concepto.Ncc_ID, Nomina_Configuracion_Concepto.Ncc_Formula_Importe, Nomina_Configuracion_Concepto.Ncc_Formula_Cantidad, Nomina_Configuracion_Concepto.Ncc_Nombre_Importe, Nomina_Configuracion_Concepto.Ncc_Nombre_Cantidad, Nomina_Concepto.Nc_Cve_Nomina_Concepto, Nomina_Concepto.Nc_Descripcion, Nomina_Concepto.Nc_ISR, Nomina_Concepto.Nc_Tipo, Nomina_Concepto.Nc_IMSS FROM Nomina_Configuracion INNER JOIN Nomina_Configuracion_Concepto on Nomina_Configuracion_Concepto.Nc_Cve_Nomina_Configuracion = Nomina_Configuracion.Nc_Cve_Nomina_Configuracion INNER JOIN Nomina_Concepto on Nomina_Concepto.Nc_Cve_Nomina_Concepto = nomina_configuracion_concepto.Nc_Cve_Nomina_Concepto WHERE Nomina_Configuracion.Nc_Cve_Nomina_Configuracion = '0001' ORDER BY Ncc_ID SELECT Nc_Descripcion FROM Nomina_Configuracion WHERE Nc_Cve_Nomina_Configuracion='0001' and es_cve_estado <> 'BA' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha INSERT INTO Transaccion_Documento_Log ( Tdl_Modulo, Tdl_Tabla, Tdl_Documento, Tdl_Tipo, Tdl_Transaccion, Tdl_Fecha, Tdl_Operador ) VALUES ( '', 'Nomina_Concepto', '0132', 'ALTA', 'CA154', GETDATE(), 'CONFIG') SELECT * FROM Transaccion_Documento_Log WHERE Tdl_Tabla= 'Nomina_Concepto' AND Tdl_Documento = '0132' AND Tdl_Tipo = 'ALTA' AND Tdl_Transaccion = 'CA154' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' *** COMMIT *** SET QUOTED_IDENTIFIER ON INSERT INTO Nomina_Concepto( Nc_Cve_Nomina_Concepto, Nc_Descripcion, Nc_Tipo, Nc_Formula, Nc_Formula_Cantidad, Nc_Cuenta_Contable, Nc_Centro_Costo, Nc_Mostrar_Pre_Nomina, Nc_Titulo_Pre_Nomina, Nc_Incidencia, Nc_ISR, Nc_IMSS, Nc_Prestacion, Nc_Requiere_Autorizacion, Nc_Nota, Nc_UserDef_1, Nc_UserDef_2, Nc_UserDef_3, Nc_UserDef_4, Nc_UserDef_5, Nc_UserDef_6, Nc_Cxc_Generar, Nc_Cxc_Cliente, Nc_Cxc_Concepto, Nc_Cxc_Comentario, Nc_Cxc_Referencia, Nc_Cxc_Relacion, Nc_Pc_Generar, Nc_Pc_Comentario, Nc_Pc_Folio_Cxc, Nc_Pc_Forma_Pago, Nc_Pc_Referencia, Nc_Pc_Relacion, Nc_Cxp_Generar, Nc_Cxp_Proveedor, Nc_Cxp_Concepto, Nc_Cxp_Comentario, Nc_Cxp_Referencia, Nc_Cxp_Relacion, Nc_Gr_Generar, Nc_Gr_Comentario, Nc_Gr_Tipo_Gasto, Nc_Gr_Centro_Costo, Nc_Gr_Referencia, Nc_Gr_UEN, Nc_Gr_Proyecto, Nc_Gr_Relacion, Nc_An_Generar, Nc_An_Proveedor, Nc_An_Comentario, Nc_An_Referencia, Nc_An_Relacion, Nc_Codigo, Nc_Tipo_Hora_Extra, Nc_Otro_Pago, Oper_Alta, Fecha_Alta, Oper_Ult_Modif, Fecha_Ult_Modif) VALUES ('0132', 'NOMINA SEMANAL DE PRODUCCION DE ELOTE', '0001', "{CONFIGURACION}", "", '', '000012', 'SI', 'NOMINA SEMANAL DE PR', 'SI','SI','SI','SI','NO','','', '', 0, 0, '2017-09-28','2017-09-28','NO', "", "", "", "", "", 'NO', "", "", "", "", "", 'NO', "", "", "", "", "", 'NO', "", "", "", "", "", "", "", 'NO', "", "", "", "", 'NSSS','','NO', 'CONFIG', '2017-09-28 22:21:36', 'CONFIG', '2017-09-28 22:21:36') SET QUOTED_IDENTIFIER OFF *** BEGIN TRANSACION *** SELECT GetDate() as Fecha SELECT Nc_Descripcion AS Nombre FROM Nomina_Concepto WHERE Nc_Cve_Nomina_Concepto = '0132' SELECT Nc_Descripcion AS Nombre FROM Nomina_Concepto WHERE Nc_Cve_Nomina_Concepto = '0132' SELECT Cc_Descripcion FROM Centro_Costo WHERE Cc_cve_Centro_Costo = '000012' SELECT Cc_Descripcion FROM Centro_Costo WHERE Cc_cve_Centro_Costo = '000012' SELECT TOP 100 Cc_Cve_Centro_Costo AS CLAVE, dbo.Get_Ruta_Centro_Costo (Cc_Cve_Centro_Costo) AS DESCRIPCION, Es_Cve_Estado as EstadoFROM Centro_CostoWHERE dbo.Get_Ruta_Centro_Costo (Cc_Cve_Centro_Costo) LIKE '%ALMACEN%' AND Es_Cve_Estado <> 'BA' SELECT TOP 100 Cc_Cve_Centro_Costo AS CLAVE, dbo.Get_Ruta_Centro_Costo (Cc_Cve_Centro_Costo) AS DESCRIPCION, Es_Cve_Estado as EstadoFROM Centro_CostoWHERE dbo.Get_Ruta_Centro_Costo (Cc_Cve_Centro_Costo) LIKE '%%' AND Es_Cve_Estado <> 'BA' SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'CENTRO_COSTO' 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 * FROM EMPRESAS..Colores WHERE Operador = 'CONFIG' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta' SELECT TOP 100 Cc_Cve_Cuenta_Contable AS CUENTA, dbo.Get_Ruta_Cuenta_Contable(Cc_Cve_Cuenta_Contable) AS DESCRIPCION, Es_Cve_Estado AS ESTADO FROM Cuenta_Contable WHERE Cc_Descripcion LIKE '%%' AND Es_Cve_Estado <> 'CA' AND Cc_Registro = 'SI'ORDER BY Cc_Cve_Cuenta_contable SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'CUENTA_CONTABLE' 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 * FROM EMPRESAS..Colores WHERE Operador = 'CONFIG' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta' SELECT Ngp_Descripcion AS Grupo, Np_Descripcion as Propiedad FROM Nomina_Propiedad inner join Nomina_Grupo_Propiedad on Nomina_Grupo_Propiedad.Ngp_Cve_Nomina_Grupo_Propiedad = Nomina_Propiedad.Ngp_Cve_Nomina_Grupo_Propiedad WHERE Nomina_Propiedad.Es_Cve_Estado <> 'BA' ORDER BY Grupo ASC, Propiedad ASC SELECT Nma_Descripcion FROM Nomina_Acumulador WHERE Es_Cve_Estado <> 'BA' ORDER BY Nma_Descripcion ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0009' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0024' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0029' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0001' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0008' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0036' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0012' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0016' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0014' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0015' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0034' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0021' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0042' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0013' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0046' ORDER BY Nfp_Id ASC SELECT Nfp_Id, Nfp_Parametro FROM Nomina_Formula_Parametro WHERE Nf_Cve_Nomina_Formula = '0025' ORDER BY Nfp_Id ASC