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.
| Author |
Topic |
|
rahul22984
Starting Member
1 Post |
 Posted - 2010-08-07 : 01:54:09
|
| I have 3 tablesstructure like thatTblteams TblTeamsMembers TblAssessmentsTId TMId EmpId TId AssessmentTypetname EmpId ItemsDesignated(we have 5 itemsDesignated) Total ScoreThe Problem is There are two type of assessments and I want To Get Avg total Score of a Team by employees score in team.Points to be considerd1. I used Group by clause but if i would mention only two assessmentTypes then query gives 10 rows (1 assessment have five rows at least) 2. only to get 5 rows with sum of two of assesments what will have to do.Please revert soon!!!Rahul |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-07 : 07:55:26
|
| please send DDL along with some sample data in order to deliver you solution to your problem. |
 |
|
|
|
|
|
Problem TO make Group Query