Buen día.
Pruebe reemplazar la consulta que se encuentra en la caja "Sentencia" del Live por la siguiente:
select cast(0 as int) as generaRecorrido, fecha_pedi,
crm_clientes.id_cliente, razonSocial, talon_ped, crm_clientes.calle + ' ' + nro_domic + ', ' + localidad + ', ' + coalesce(nombre_pro collate latin1_general_bin,'') as direccion,
nro_pedido,
cast(total_pedi as int) as total,
(select count(1) as canti from gva03 where gva03.talon_ped=gva21.talon_ped and gva03.nro_pedido=gva21.nro_pedido) as cantidadRenglones,
cast((select sum(cant_pedid) as canti from gva03 where gva03.talon_ped=gva21.talon_ped and gva03.nro_pedido=gva21.nro_pedido) as decimal(18,2)) as cantidadBultos,
cast((select sum(cant_pedid*pto_pedido) as canti from gva03 inner join sta11 on gva03.cod_articu=sta11.cod_articu where gva03.talon_ped=gva21.talon_ped and gva03.nro_pedido=gva21.nro_pedido)/100 as decimal(18,2)) as cantidadM3
,leyenda_5,
id_gva21 as id_gva21_oculto,
cast(datepart(yy,getdate()) as varchar)+'_'+cast(datepart(MM,getdate()) as varchar)+'_'+cast(datepart(d,getdate()) as varchar)+'_'+cast(datepart(hour,getdate()) as varchar)+'_'+cast(datepart(minute,getdate()) as varchar)+'_'+cast(datepart(second,getdate()) as varchar) as fechaEntrega_oculto,
'Update gva21 set leyenda_5=''?fechaEntrega_oculto?'' where id_gva21=?id_gva21_oculto?' as recorrido_accion
from gva21 inner join crm_clientes on gva21.cod_client=crm_clientes.cod_tango
left join gva18 on crm_clientes.provincia=cod_provin
where (fecha_pedi between ??desdeFecha?? and ??hastaFecha?? and leyenda_5='' and ??id_entrega??='') or (leyenda_5=??id_entrega?? and ??id_entrega??<>'')
Un abrazo.
Tweet
RECORRIDO DE ENTREGA
Opciones de tema
