DECLARE @startDate DATETIME
DECLARE @endDate DATETIME
DECLARE @idTerminal VARCHAR(4)
SET @startDate = '2019-12- 00:00:00.000'
SET @endDate = '2019-12- 23:59:59.999'
SET @idTerminal = '%'

select cast(date_created as date),sum(bruto_pstv-bruto_ngtv) venta
from venta
where date_created between @startDate and @endDate
and cod_terminal like @idTerminal
and id_tipo_transac in ('0','20')
group by cast(date_created as date)
order by cast(date_created as date)


select cast(date_created as date),sum(valor_venta) ventas_articulo
from ventas_articulo
where date_created between @startDate and @endDate
and cod_terminal like @idTerminal
group by cast(date_created as date)
order by cast(date_created as date)

select cast(vmp.date_created as date),sum(valor) ventas_medios_pago
from venta v inner join ventas_medios_pago vmp
on vmp.id_venta = v.id_venta
where v.date_created between @startDate and @endDate
and id_terminal like @idTerminal
and v.id_tipo_transac in ('0','20')
group by cast(vmp.date_created as date)
order by cast(vmp.date_created as date)


select cast(date_created as date), sum(total) totales_medio_pago
 from totales_medio_pago
 where date_created between @startDate and @endDate and
id_registro_venta in (select id_registro_venta from registro_venta where date_created between @startDate and @endDate and cod_terminal like  @idTerminal)
group by cast(date_created as date)
order by cast(date_created as date)

select cast(date_created as date),sum(bruto_pstv-bruto_ngtv) registro_venta
from registro_venta
where date_created between @startDate and @endDate
and cod_terminal like @idTerminal
group by cast(date_created as date)
order by cast(date_created as date)