SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PREFIJO_FOLIOS_EMPRESA'
SELECT Fl_Folio FROM Folio WHERE Fl_Tabla = 'CAJA:000001'
SELECT Pr_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Flash Mobile' AND Psp_Monto = '50'
SELECT Psp_Cve_Producto AS Nombre FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Flash Mobile' AND Psp_Monto = '50'
SELECT Psp_Monto FROM Pos_Servicio_Producto WHERE Psp_Descripcion = 'Flash Mobile' ORDER BY Psp_Monto 
SELECT Psp_Descripcion FROM Pos_Servicio_Producto WHERE Psp_Grupo = 'TAE' GROUP BY Psp_Descripcion, Psp_Cve_Producto ORDER BY Psp_Cve_Producto ,Psp_Descripcion 
SELECT * FROM Pos_Servicio_Configuracion 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS'
SELECT Clave FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE'
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 = '0001'
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 * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RFC'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
EXEC SP_RPT_FTTK02_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID
EXEC SP_RPT_FTTK02_2 '0001'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'FTTK02'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_3 '01-0001899'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
EXEC SP_RPT_FTTK01_1 '0001'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID
EXEC SP_RPT_FTTK01_2 '0001'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'FTTK01'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_1 '01-0001899'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID
EXEC SP_RPT_VNTK01_2 '01-0001899'
SELECT TOP 1      Fr_Procedure1,      Fr_Procedure2,      Fr_Procedure3,      Fr_LineasDetalle,      Fr_Caida_Libre FROM      Formato WHERE      Fr_Cve_Formato = 'VNTK01'
SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0001899'
SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000008'
*** COMMIT ***
SELECT    Obj.name AS Nombre,    Obj.type AS Tipo,    Obj.type_desc AS nTiop,    Modu.definition AS Consulta FROM CRISTOREY.sys.objects Obj    INNER JOIN CRISTOREY.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE    (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'VENTA' AND    Es_Cve_Estado <> 'BA') ) AND    Obj.type = 'P' ORDER BY Obj.name ASC 
SELECT @@VERSION AS xVersion 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION_SQL_AFECTAR'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_HISTORIAL_SEGUIMIENTO'
SELECT Cl_Cve_Cliente AS Nombre FROM Venta WHERE Vn_Folio = '01-0001899'
SELECT Vn_Fecha AS Nombre FROM Venta WHERE Vn_Folio = '01-0001899'
SELECT    Poliza_Configuracion.Pc_Cve_Poliza_Configuracion,    Poliza_Configuracion.Pc_Descripcion,    Poliza_Configuracion.Pc_Tabla FROM Poliza_Configuracion    INNER JOIN Poliza_Configuracion_Tabla ON Poliza_Configuracion.Pc_Tabla = Poliza_Configuracion_Tabla.Pc_Tabla WHERE    Poliza_Configuracion_Tabla.Pc_Tabla = 'VENTA' AND    Poliza_Configuracion.Es_Cve_Estado <> 'BA' AND Poliza_Configuracion_Tabla.Pc_Contabiliza_Linea = 'SI' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_CENTRO_COSTO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_PERIODO_ACTUAL'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CON_EJERCICIO_ACTUAL'