Hallo,

vielleicht nicht das shönste SQL-statement und nicht ganz genau was sie wollen, aber ich würde das so machen:

with t1 as (
select twerk, tuser, cast(month(tdatum) as char(10)) as d1,
' ' concat cast(tdatum as char(10)) as d2,
sum(tstd) from qtemp/t
group by twerk, tuser, tdatum),
t2 as (
select twerk, tuser, cast(month(tdatum) as char(10)) as h1,
tstd
from qtemp/t),
t3 as (
select twerk, tuser, h1 as d1, '_' as d2, sum(tstd) from t2
group by twerk, tuser, h1)
select * from t1
union all
select * from t3
order by twerk, tuser, d1, d2

Grüsse,

Jan