Por cierto olvide poner el query que me devuelve unos y ceros jeje
Código Delphi
[-]select distinct
clavealumno as clave,
count( registroentrada) as entrada,
count( case when cast (entrada as date) = '10/01/2010' then 0 end ) as dia1,
count( case when cast (entrada as date) = '10/02/2010' then 0 end ) as dia2,
count( case when cast (entrada as date) = '10/03/2010' then 0 end ) as dia3,
count( case when cast (entrada as date) = '10/04/2010' then 0 end ) as dia4,
count( case when cast (entrada as date) = '10/05/2010' then 0 end ) as dia5,
count( case when cast (entrada as date) = '10/06/2010' then 0 end ) as dia6,
count( case when cast (entrada as date) = '10/07/2010' then 0 end ) as dia7,
count( case when cast (entrada as date) = '10/08/2010' then 0 end ) as dia8,
count( case when cast (entrada as date) = '10/09/2010' then 0 end ) as dia9,
count( case when cast (entrada as date) = '10/10/2010' then 0 end ) as dia10,
count( case when cast (entrada as date) = '10/11/2010' then 0 end ) as dia11,
count( case when cast (entrada as date) = '10/12/2010' then 0 end ) as dia12,
count( case when cast (entrada as date) = '10/13/2010' then 0 end ) as dia13,
count( case when cast (entrada as date) = '10/14/2010' then 0 end ) as dia14,
count( case when cast (entrada as date) = '10/15/2010' then 0 end ) as dia15
from asistencia
where
(
(clavealumno < 400)
and
(registroentrada between cast('10/1/2010'as date) and cast('10/15/2010' as date))
)
group by clavealumno
order by 1