SQLQuery add different columns of the same table and group them by dates

1

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 .. !!

    
asked by Elky Rubi Mostacero Oribe 26.06.2018 в 04:02
source

0 answers