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 = '0000002378' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 11:51:19.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 = '0000002378' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 11:51:19.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 = '0000002378' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 11:51:19.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 = '0000002378' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 11:51:19.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 = '0000002378' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 11:51:19.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 = '0000002378' 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 = '0000002378'
SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', 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 = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'DP' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'DP' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'DP' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'DP' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'DP' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'CT' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'CT' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'CT' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'CT' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'CT' AND (Of_Valor_Clasificador = '0000' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'PR' AND (Of_Valor_Clasificador = '0000002378' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'SE' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'PR' AND (Of_Valor_Clasificador = '0000002378' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'RU' AND (Of_Valor_Busqueda = '0000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'PR' AND (Of_Valor_Clasificador = '0000002378' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'GR' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'PR' AND (Of_Valor_Clasificador = '0000002378' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CA' AND (Of_Valor_Busqueda = '0000000000' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' 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 11:51:19.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2024-04-28')))) + '%', Of_Dias_Aplicacion ) > 0 AND (Of_Sucursal = '0001' OR Of_Sucursal = '%') AND (Of_Tipo_Clasificador = 'PR' AND (Of_Valor_Clasificador = '0000002378' OR Of_Valor_Clasificador = '%' ) ) AND (Of_Tipo = 'CL' AND (Of_Valor_Busqueda = '0000000001' OR Of_Valor_Busqueda = '%') ) AND '2024-04-28' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC
SET DATEFIRST 1
SELECT GetDate() as Fecha
SELECT Producto.Pr_Cve_Producto, Producto.Pr_Descripcion, Producto.Pr_Unidad_Venta, Producto.Ct_Cve_Categoria, Producto.Dp_Cve_Departamento, Producto.Mr_Cve_Marca, Producto.Ln_Cve_Linea, Producto.Fm_Cve_Familia, Producto.Sf_Cve_Subfamilia FROM Producto WHERE Pr_Cve_Producto = '0000002378'