INSERT INTO POS_Producto_Cancelado ( POS_Folio , Ppc_ID , Ca_Cve_Cajero , Ppc_Fecha_Cancelacion , Pr_Cve_Producto , Ppc_Tipo_Cancelacion , Ppc_Cantidad , Ppc_Precio )VALUES ( '01-0000001', '10000', '', '2021-08-08 15:48:14', '0000001553', '02',0.32,4.8 ) SELECT IsNull(MAX(Ppc_ID),0) as MaxID FROM POS_Producto_Cancelado WHERE ISNUMERIC(Ppc_ID) = 1 AND POS_Folio = '01-0000001' SELECT Pr_Cve_Producto FROM Producto WHERE Pr_Clave_Corta ='001553' SELECT Producto.Pr_Cve_Producto,Producto.Pr_Clave_Corta 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 = '990015530000' *** BEGIN TRANSACION *** SELECT GetDate() as Fecha INSERT INTO POS_Producto_Cancelado ( POS_Folio , Ppc_ID , Ca_Cve_Cajero , Ppc_Fecha_Cancelacion , Pr_Cve_Producto , Ppc_Tipo_Cancelacion , Ppc_Cantidad , Ppc_Precio )VALUES ( '01-0000001', '10000', '', '2021-08-08 15:48:10', '0000001553', '02',0.32,4.8 ) SELECT IsNull(MAX(Ppc_ID),0) as MaxID FROM POS_Producto_Cancelado WHERE ISNUMERIC(Ppc_ID) = 1 AND POS_Folio = '01-0000001' SELECT Pr_Cve_Producto FROM Producto WHERE Pr_Clave_Corta ='001553' SELECT Producto.Pr_Cve_Producto,Producto.Pr_Clave_Corta 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 = '990015530000' *** BEGIN TRANSACION *** SELECT GetDate() as Fecha 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 = '0000000830' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 15:47:55.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 = '0000000830' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 15:47:55.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 = '0000000830' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 15:47:55.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 = '0000000830' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 15:47:55.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 = '0000000830' OR Ppc.Ppc_Producto = '%') AND '1899-12-30 15:47:55.000' BETWEEN Pp.Pp_Hora_Inicial AND Pp.Pp_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(DATEPART(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 = '0000000830' 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 = '0000000830' SELECT TOP 1 Of_Cantidad, Of_Oferta, Of_Sin_Cargo as Of_Precio FROM Oferta_Clasificador WHERE '1899-12-30 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' 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 15:47:55.000' between Of_Hora_Inicial AND Of_Hora_Final AND PATINDEX ('%' + rtrim(ltrim(str(datepart(weekday,'2021-02-14')))) + '%', 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 '2021-02-14' BETWEEN Of_Fecha_Inicial AND Of_Fecha_Final AND Es_Cve_Estado = 'LI' ORDER BY Of_Folio DESC, Of_Cantidad DESC