Boa tarde,
Experimente mais ou menos dessa forma:
with
CTE_T1 as
(
select
Data,
sum(Valor1) as Valor1,
sum(Valor2) as Valor2,
sum(Valor3) as Valor3
from Tabela1
group by
Data
),
CTE_T2 as
(
select
Data,
sum(Valor4) as Valor4
from Tabela1
group by
Data
)
select
isnull(t1.Data, t2.Data) as Data,
isnull(t1.Valor1, 0) as Valor1,
isnull(t1.Valor2, 0) as Valor2,
isnull(t1.Valor3, 0) as Valor3,
isnull(t2.Valor4, 0) as Valor4
from CTE_T1 as t1
full join CTE_T2 as t2
on t2.Data = t1.Data
Espero que ajude.
Assinatura: http://www.imoveisemexposicao.com.br
