Sunday, July 21, 2013

[SQL Server] Count and Percentage of skill ratings

[SQL Server] Count and Percentage of skill ratings

Count and Percentage of skill ratings

Posted: 21 Jul 2013 05:21 AM PDT

Hi all--I have a program which brings in Skill ratings for an assessment people with the title of "Worker" have to take along with a file number they are assigned. The program also brings in the reporting line that each worker is a part of. SELECT distinct o.VP,o.AVP,o.Director,o.Supervisor,o.Worker,bs.File_NBR,s.Skillbs.scoreFROM [New_EEs].[dbo].[SBC_Best_Scores] bsinner join new_ees.dbo.SBC_Skills son bs.Skill_NBR=s.SKILL_NBRinner join gw_PPP.dbo.Org_Hierarchy oon bs.File_NBR=o.File_NBR;VP AVP Director Supervisor Worker File_NBR Skill SCOREGerald Kris Doris NULL Mack 107812 B2 4Gerald Kris Doris NULL Mack 107812 D1 3Gerald Kris Doris NULL Mack 107812 D2 3Gerald Kris Doris NULL Mack 107812 D3 3Gerald Kris Doris NULL Mack 107812 E1 4Gerald Kris Mike NULL Brady 109080 A1 5Gerald Kris Mike NULL Brady 109080 B1 4Gerald Kris Mike NULL Brady 109080 B2 3Gerald Kris Mike NULL Brady 109080 B3 4Gerald Kris Mike NULL Brady 109080 C1 4Gerald Kris Mike NULL Brady 109080 C2 4Gerald Kris Mike NULL Brady 109080 C3 0Kim Harry NULL Grant Tom 108457 B1 4Kim Harry NULL Grant Tom 108457 B2 4Kim Harry NULL Grant Tom 108457 C1 4Kim Harry NULL Grant Tom 108457 C2: 5Kim Harry NULL Grant Tom 108457 C5 5Kim Harry NULL Grant Tom 108457 D1 4Kim Harry NULL Grant Tom 108457 D2 5Kim Harry NULL Grant Tom 108457 D3 4Kim Harry NULL Grant Jean 106934 C5 4Kim Harry NULL Grant Jean 106934 D1 5Kim Harry NULL Grant Jean 106934 D3 5Kim Harry NULL Grant Raphe 108901 B2 5Kim Harry NULL Grant Raphe 108901 C2 5Kim Harry NULL Grant Raphe 108901 C3 4Kim Harry NULL Grant Raphe 108901 C5 5Kim Harry NULL Grant Raphe 108901 D2 5Kim Harry NULL Grant Raphe 108901 E1 5Kim Harry NULL Grant Tyika 107923 B1 5Kim Harry NULL Grant Tyika 107923 B2 5Kim Harry NULL Grant Tyika 107923 D2 4Kim Harry NULL Grant Tyika 107923 D3 4The rating levels are 1 through 5. What I need to do is to do is create a table that shows the count and percentage of each rating giving to the workers for each skill grouped by Vp, AVP, Supervisor and Director. So all the works that are Ultimately under a AVP and all the wokers that are Ultimately under a director and so on.Name Role Skill Count of % of Count of % of Rating 1 Rating 1 Rating 2 Rating 2Gerald VP A1 100 29% 130 33%Gerald VP B1 95 28% 95 24%Gerald VP B2 120 35% 70 18%Gerald VP B3 30 9% 100 25%Kim VP A1 Kim VP B1 Kim VP B2 AND SO ON Kim VP B3 Kris AVP A1 Kris AVP B1 Kris AVP B2 Kris AVP B3 Harry AVP A1 Harry AVP B1 Harry AVP B2 Harry AVP B3 Doris Director A1 Doris Director B1 Doris Director B2 Doris Director B3 Mike Director A1 Mike Director B1 Mike Director B2 Mike Director B3 Grant Supervisor A1 Grant Supervisor B1 Grant Supervisor B2 Grant Supervisor B3 I am new to SQL server and I'm have trouble figireing this out. Any help would be great, thanks!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog