Comments by Inderjeet Kaur (Top 4 by date)

How to set size of image while saving the path to database?

I have rectified the query and the error is
"Incorrect syntax near the keyword 'GROUP'."



SELECT 'Total' AS Total, SUM([Coding]), SUM([Unit Testing]),
SUM([User Manual]), SUM([Meetings]), SUM([Testing])
FROM (SELECT
Name,
[Coding],[Unit Testing],[User Manual],[Meetings],[Testing],
TaskDate,
COALESCE([Coding],0) + COALESCE([Unit Testing],0) +
COALESCE([User Manual],0) + COALESCE([Meetings],0) +
COALESCE([Testing],0) AS Total
FROM (SELECT
TaskTitle As Title,
Hours,
Employee_Name AS Name,
TaskDate
FROM TimeSheet TS,
employee E,
Timesheetdetails TSD,
Task T
WHERE
TS.EmployeeID = E.Employee_EmpID AND
TSD.TaskID = T.TaskID AND
TS.TImeSheetID = TSD.TimeSheetID AND
T.Status='A' AND
TS.ProjectID = 43 AND
TSD.TaskDate >='09/26/2011' AND
TSD.TaskDate<='10/02/2011'
) up
PIVOT (SUM(Hours) FOR Title IN ([Coding], [Unit Testing],
[User Manual],
[Meetings],[Testing])) AS pvt
)
GROUP BY SUM([Coding]), SUM([Unit Testing]), SUM([User Manual]),
SUM([Meetings]), SUM([Testing])

I have 50 employees how will i bring them to header and assign their hours to them downunder