need to group by projectid - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need to group by projectid

Author

Topic

mcupryk
Yak Posting Veteran

91 Posts

Posted - 2011-03-16 : 12:30:53

SELECT
dbo.tblTaskList.TaskID,
dbo.tblTaskList.ProjectID,
dbo.tblTaskList.UserID,
dbo.tblTaskList.TriggerDate,

dbo.tblProject.ProjectNumber,
dbo.tblProject.ProjectName,

dbo.tblTaskList.OtherDescrip,
dbo.tblTaskList.Completed,

dbo.tblTaskType.TaskType AS TaskName,
dbo.tblTaskType.TaskTypeID
FROM dbo.tblTaskList
LEFT OUTER JOIN dbo.tblTaskType ON dbo.tblTaskList.TaskType = dbo.tblTaskType.TaskTypeID
LEFT OUTER JOIN dbo.tblProject ON dbo.tblTaskList.ProjectID = dbo.tblProject.ProjectID
Where dbo.tblTaskList.Completed ='true'
GROUP BY dbo.tblTaskList.ProjectID
ORDER BY dbo.tblTaskList.UserID, dbo.tblTaskList.TriggerDate

Msg 8120, Level 16, State 1, Line 2
Column 'dbo.tblTaskList.TaskID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Any help would be awesome.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2011-03-16 : 12:48:41

You have to group by everything you're not aggregating

GROUP BY
dbo.tblTaskList.TaskID,
dbo.tblTaskList.ProjectID,
dbo.tblTaskList.UserID,
dbo.tblTaskList.TriggerDate,
dbo.tblProject.ProjectNumber,
dbo.tblProject.ProjectName,
dbo.tblTaskList.OtherDescrip,
dbo.tblTaskList.Completed,
dbo.tblTaskType.TaskType,
dbo.tblTaskType.TaskTypeID

Jim

Everyday I learn something that somebody else already knew

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources