SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Producto.Pr_Cve_Producto, Producto.Pr_Clave_Corta, Producto_Talla_Color.Tl_Cve_Talla, Producto_Talla_Color.Cl_Cve_Color FROM Producto INNER JOIN Producto_Talla_Color ON Producto.Pr_Cve_Producto = Producto_Talla_Color.Pr_Cve_Producto WHERE '99' + Pr_Clave_Corta + Tl_Cve_Talla + Cl_Cve_Color = '990031320000' *** BEGIN TRANSACION *** SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Producto.Pr_Cve_Producto, Producto.Pr_Clave_Corta, Producto_Talla_Color.Tl_Cve_Talla, Producto_Talla_Color.Cl_Cve_Color FROM Producto INNER JOIN Producto_Talla_Color ON Producto.Pr_Cve_Producto = Producto_Talla_Color.Pr_Cve_Producto WHERE '99' + Pr_Clave_Corta + Tl_Cve_Talla + Cl_Cve_Color = '990031320000' *** BEGIN TRANSACION *** SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'POS_VER_PROMOCION_AL_FINALIZAR' SELECT Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor FROM Promocion_Pv Pp INNER JOIN Promocion_Pv_Clasificador Ppc on Pp.Pp_Folio = Ppc.Pp_Folio WHERE Pp.Pp_Tipo = '02' AND Pp.Pp_Tipo_Valor <= 1 AND (Ppc.Ppc_Categoria = '0000' OR Ppc.Ppc_Categoria = '%') AND (Ppc.Ppc_Departamento = '0000' OR Ppc.Ppc_Departamento = '%') AND (Ppc.Ppc_Marca = '0000' OR Ppc.Ppc_Marca = '%') AND (Ppc.Ppc_Linea = '0000' OR Ppc.Ppc_Linea = '%') AND (Ppc.Ppc_Familia = '0000' OR Ppc.Ppc_Familia = '%') AND (Ppc.Ppc_SubFamilia = '0000' OR Ppc.Ppc_SubFamilia = '%') AND (Ppc.Ppc_Producto = '0000003132' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 19:35:38.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2025-09-06')))) + '%', Pp.Pp_Dias_Aplicacion ) > 0 AND (Pp.Pp_Sucursal = '0001' OR Pp.Pp_Sucursal = '%') AND Pp.Pp_Aplicar = 'SG' AND (Pp.Pp_Aplicar_Valor = '0000' OR Pp.Pp_Aplicar_Valor = '%') AND '2025-09-06' BETWEEN Pp.Pp_Fecha_Inicial AND Pp.Pp_Fecha_Final AND Pp.Es_Cve_Estado ='LI' GROUP BY Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor ORDER BY Pp_Folio DESC SELECT Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor FROM Promocion_Pv Pp INNER JOIN Promocion_Pv_Clasificador Ppc on Pp.Pp_Folio = Ppc.Pp_Folio WHERE Pp.Pp_Tipo = '02' AND Pp.Pp_Tipo_Valor <= 1 AND (Ppc.Ppc_Categoria = '0000' OR Ppc.Ppc_Categoria = '%') AND (Ppc.Ppc_Departamento = '0000' OR Ppc.Ppc_Departamento = '%') AND (Ppc.Ppc_Marca = '0000' OR Ppc.Ppc_Marca = '%') AND (Ppc.Ppc_Linea = '0000' OR Ppc.Ppc_Linea = '%') AND (Ppc.Ppc_Familia = '0000' OR Ppc.Ppc_Familia = '%') AND (Ppc.Ppc_SubFamilia = '0000' OR Ppc.Ppc_SubFamilia = '%') AND (Ppc.Ppc_Producto = '0000003132' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 19:35:38.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2025-09-06')))) + '%', Pp.Pp_Dias_Aplicacion ) > 0 AND (Pp.Pp_Sucursal = '0001' OR Pp.Pp_Sucursal = '%') AND Pp.Pp_Aplicar = 'RU' AND (Pp.Pp_Aplicar_Valor = '0000' OR Pp.Pp_Aplicar_Valor = '%') AND '2025-09-06' BETWEEN Pp.Pp_Fecha_Inicial AND Pp.Pp_Fecha_Final AND Pp.Es_Cve_Estado ='LI' GROUP BY Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor ORDER BY Pp_Folio DESC SELECT Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor FROM Promocion_Pv Pp INNER JOIN Promocion_Pv_Clasificador Ppc on Pp.Pp_Folio = Ppc.Pp_Folio WHERE Pp.Pp_Tipo = '02' AND Pp.Pp_Tipo_Valor <= 1 AND (Ppc.Ppc_Categoria = '0000' OR Ppc.Ppc_Categoria = '%') AND (Ppc.Ppc_Departamento = '0000' OR Ppc.Ppc_Departamento = '%') AND (Ppc.Ppc_Marca = '0000' OR Ppc.Ppc_Marca = '%') AND (Ppc.Ppc_Linea = '0000' OR Ppc.Ppc_Linea = '%') AND (Ppc.Ppc_Familia = '0000' OR Ppc.Ppc_Familia = '%') AND (Ppc.Ppc_SubFamilia = '0000' OR Ppc.Ppc_SubFamilia = '%') AND (Ppc.Ppc_Producto = '0000003132' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 19:35:38.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2025-09-06')))) + '%', Pp.Pp_Dias_Aplicacion ) > 0 AND (Pp.Pp_Sucursal = '0001' OR Pp.Pp_Sucursal = '%') AND Pp.Pp_Aplicar = 'GC' AND (Pp.Pp_Aplicar_Valor = '0000000000' OR Pp.Pp_Aplicar_Valor = '%') AND '2025-09-06' BETWEEN Pp.Pp_Fecha_Inicial AND Pp.Pp_Fecha_Final AND Pp.Es_Cve_Estado ='LI' GROUP BY Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor ORDER BY Pp_Folio DESC SELECT Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor FROM Promocion_Pv Pp INNER JOIN Promocion_Pv_Clasificador Ppc on Pp.Pp_Folio = Ppc.Pp_Folio WHERE Pp.Pp_Tipo = '02' AND Pp.Pp_Tipo_Valor <= 1 AND (Ppc.Ppc_Categoria = '0000' OR Ppc.Ppc_Categoria = '%') AND (Ppc.Ppc_Departamento = '0000' OR Ppc.Ppc_Departamento = '%') AND (Ppc.Ppc_Marca = '0000' OR Ppc.Ppc_Marca = '%') AND (Ppc.Ppc_Linea = '0000' OR Ppc.Ppc_Linea = '%') AND (Ppc.Ppc_Familia = '0000' OR Ppc.Ppc_Familia = '%') AND (Ppc.Ppc_SubFamilia = '0000' OR Ppc.Ppc_SubFamilia = '%') AND (Ppc.Ppc_Producto = '0000003132' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 19:35:38.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2025-09-06')))) + '%', Pp.Pp_Dias_Aplicacion ) > 0 AND (Pp.Pp_Sucursal = '0001' OR Pp.Pp_Sucursal = '%') AND Pp.Pp_Aplicar = 'CA' AND (Pp.Pp_Aplicar_Valor = '0000000000' OR Pp.Pp_Aplicar_Valor = '%') AND '2025-09-06' BETWEEN Pp.Pp_Fecha_Inicial AND Pp.Pp_Fecha_Final AND Pp.Es_Cve_Estado ='LI' GROUP BY Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor ORDER BY Pp_Folio DESC SELECT Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor FROM Promocion_Pv Pp INNER JOIN Promocion_Pv_Clasificador Ppc on Pp.Pp_Folio = Ppc.Pp_Folio WHERE Pp.Pp_Tipo = '02' AND Pp.Pp_Tipo_Valor <= 1 AND (Ppc.Ppc_Categoria = '0000' OR Ppc.Ppc_Categoria = '%') AND (Ppc.Ppc_Departamento = '0000' OR Ppc.Ppc_Departamento = '%') AND (Ppc.Ppc_Marca = '0000' OR Ppc.Ppc_Marca = '%') AND (Ppc.Ppc_Linea = '0000' OR Ppc.Ppc_Linea = '%') AND (Ppc.Ppc_Familia = '0000' OR Ppc.Ppc_Familia = '%') AND (Ppc.Ppc_SubFamilia = '0000' OR Ppc.Ppc_SubFamilia = '%') AND (Ppc.Ppc_Producto = '0000003132' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 19:35:38.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2025-09-06')))) + '%', Pp.Pp_Dias_Aplicacion ) > 0 AND (Pp.Pp_Sucursal = '0001' OR Pp.Pp_Sucursal = '%') AND Pp.Pp_Aplicar = 'CL' AND (Pp.Pp_Aplicar_Valor = '0000000001' OR Pp.Pp_Aplicar_Valor = '%') AND '2025-09-06' BETWEEN Pp.Pp_Fecha_Inicial AND Pp.Pp_Fecha_Final AND Pp.Es_Cve_Estado ='LI' GROUP BY Pp.Pp_Folio, Pp.Pp_Comentario, Pp.Pp_Tipo_Valor ORDER BY Pp_Folio DESC SET DATEFIRST 1 SELECT GetDate() as Fecha SELECT Pr_Cve_Producto, Ct_Cve_Categoria, Dp_Cve_Departamento, Mr_Cve_Marca, Ln_Cve_Linea, Fm_Cve_Familia, Sf_Cve_SubFamilia, Pr_Tipo_Producto FROM Producto WHERE Pr_Cve_Producto = '0000003132' AND Es_Cve_Estado <> 'BA' SELECT Cc_Cve_Cadena_Comercial, Sg_Cve_Segmento, Gc_Cve_Grupo_Comercial, Rt_Cve_Ruta FROM Cliente WHERE Cl_Cve_Cliente = '0000000001' SELECT Pr_Producto, Producto.Pr_Descripcion, Producto.Pr_Unidad_Venta FROM Producto_Relacionado INNER JOIN Producto ON Producto.Pr_Cve_Producto = Producto_Relacionado.Pr_Producto WHERE Producto_Relacionado.Pr_Cve_Producto = '0000003132' SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'SF' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'SF' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'SF' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'SF' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'SF' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'FM' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'FM' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'FM' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'FM' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'FM' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'LN' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'LN' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'LN' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'LN' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'LN' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'MR' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 19:35:37.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2025-09-06')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'MR' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2025-09-06' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC