SQL Query Hilfe

[DeddyH]

Versuch es mal so:

SQL-Code:

Select ActivityDate, 
  SUM(CASE FK_ActivityTypeID WHEN 1 THEN Timespan ELSE 0 END) AS 'Billable Hours',
  SUM(CASE FK_ActivityTypeID WHEN 0 THEN Timespan ELSE 0 END) AS 'Non-Billable Hrs',
  SUM(Timespan) as TotalTime                                                                                     
FROM TB_AM_Hours
WHERE
  FK_UserID = 1         
  and ActivityDate >= '03.03.2008 00:00:00'
  and ActivityDate <= '09.03.2008 00:00:00'
  and FK_ProgramID =  1
group by ActivityDate;

[edit] Sry, falsches Feld summiert [/edit]