Someone who can help me with this query please. I have DIFFERENT dates and units in the same Table. I would like to add them and group them by date.
Example. Queries
SELECT
T0.PRODUCTO AS 'Producto'
,CONVERT(VARCHAR(12), T0.[DFEC_DEV1] ,103) AS 'F.Dev 1'
,CONVERT(int, T0.DCANT_DEV1 ,103) AS 'Und Dev1'
,CONVERT(VARCHAR(12), T0.[DFEC_DEV2] ,103) AS 'F.Dev 2'
,CONVERT(int, T0.DCANT_DEV2 ,103) AS 'Und Dev2'
,CONVERT(VARCHAR(12), T0.[DFEC_DEV3] ,103) AS 'F.Dev 3'
,CONVERT(int, T0.DCANT_DEV3 ,103) AS 'Und Dev3'
,CONVERT(VARCHAR(12), T0.[FechaDate],103) AS 'Fecha de Venta'
FROM TABLA T0
WHERE T0.[FechaDate] Between '01/06/2018' and '01/06/2018'
AND T0.CCPRODUCTO ='LI'
AND T0.DCANT_DEV1 != '0'
Subquerys
I have tried a form and group them by detailed dates. With the following query.
select T0.PRODUCTO as 'Producto'
,CONVERT(VARCHAR(12), T0.[DFEC_DEV1] ,103) AS 'Fechas Devoluciones'
, CONVERT(int, T0.DCANT_DEV1 ,103) as 'Devoluciones Und'
from
(
select T0.PRODUCTO,T0.[DFEC_DEV1],(T0.DCANT_DEV1)
from TABLA T0
Where T0.[FechaDate] Between '01/06/2018' and '01/06/2018'
and T0.PRODUCTO ='LI'
AND T0.DCANT_DEV1!= '0'
UNION ALL
select T0.PRODUCTO,T0.[DFEC_DEV2],(T0.DCANT_DEV2)
from TABLA T0
Where T0.[FechaDate] Between '01/06/2018' and '01/06/2018'
and T0.PRODUCTO ='LI'
AND T0.DCANT_DEV2!= '0'
UNION ALL
select T0.PRODUCTO,T0.[DFEC_DEV3],(T0.DCANT_DEV3)
from TABLA T0
Where T0.[FechaDate] Between '01/06/2018' and '01/06/2018'
and T0.PRODUCTO ='LI'
AND T0.DCANT_DEV3!= '0'
) T0
group by T0.DCANT_DEV1,T0.PRODUCTO,T0.[DFEC_DEV1]
Staying Like
Now I would like you to help me Group the total by dates, but also indicate that in F.Dev3 It can be a date of 05/31 or 29/05, etc.
I would like it to be shown like this.
Waiting for your comments, Thanks .. !!