lo solucioné de esta manera
-- aqui tengo las ventas en rango de fecha o en el dia.. dependiendo del where
Código SQL
[-]SELECT Left(hora,2) as hora, a.IDEN, Sum (d.PT) as PT into #d
FROM TBLCONSUMOC c
left join tblconsumod d on c.tdc = d.tdc and c.doc = d.doc
left join tblarticulo a on d.kod = a.kod
where
convert(varchar, c.f_doc, 112) = '20231225' and ISNULL(c.sts,'') = ''
group by Left(hora,2), a.iden
order by Left(hora,2), a.iden
Código SQL
[-]
select r1.kod, r1.descl, SUM(PT) from (Select * from tblturno) r1, #d
where hora between r1.hini and r1.nfin
group by r1.kod, r1.descl
aqui obtengo lo que deseo
lo dejo por si le puede servir a alguien