x

[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

essence2012388 gravatar image

essence2012388
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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x587
x371
x6

asked: Mar 23, 2012 at 07:56 PM

Seen: 1127 times

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