[Closed] 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?

more ▼

asked Mar 23, 2012 at 07:56 PM in Default

avatar image

0 5 5 6

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

Mar 23, 2012 at 08:28 PM KenJ
(comments are locked)
10|1200 characters needed characters left

The question has been closed Mar 24, 2012 at 04:25 PM by ThomasRushton for the following reason:

Duplicate Question

0 answers: sort voted first

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 23, 2012 at 07:56 PM

Seen: 1416 times

Last Updated: Mar 23, 2012 at 08:28 PM

Copyright 2018 Redgate Software. Privacy Policy