question

essence2012388 avatar image
essence2012388 asked

How to show the percent completion of each division in each course?

Hello everybody, I am a new ASP.NET developer and I am working now on my first web-based application for my company. The applicaiton tracks the training courses which the employees took or attended them. I want to show a percent completion of each division in my department in each one of these courses. The courses are divided into three groups. I have the following database design: Employee Table: Username, Name, DivisionCode Division Table: DivisionCode, DivisionName Course Table: CourseID, CourseName, GroupID Group Table: GroupID, GroupName Employee_Course Table: Username, CourseID (The first attribure in each table is the primary key) So how I can be able to show the percent completion for each division: 1. in all courses 2. in each group of courses **I need to two queries to show each one of the above requirements. So how to do that?**
sql-server-2008-r2queryquery-designer
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is this, perhaps, a homework question? The exact same question was posted here several weeks ago: http://ask.sqlservercentral.com/questions/87386/how-to-display-the-percent-completion.html
0 Likes 0 ·

0 Answers