TABLE LAYOUT

 

 

Instructions

 

 

 

The database server which is being queried is running SQL 2000 sp3.

 

What is required is as follows:

 

For the position ‘Corp HR-People Development-Wellness-Manager(Process)’ I would like to see each linked competency for the position ordered by the level at which the competency exists descending with a column for each person and the level at which they have that competency. 

 

I only want to see results for users with the following userids '999209','helpdesk1','999339','helpdesk5','999827'

Even if they don’t have records in compuser.

 

 

So the first competency will look like this:

 

compname

firstname

surname

positionlevel

userlevel

04 Boss Relationships

Andrew.

Matlala

2

1

04 Boss Relationships

Sikelela

Mkhabela

2

1

04 Boss Relationships

Tebogo.

Moromane

2

1

04 Boss Relationships

Mustafa

Motalib

2

0

04 Boss Relationships

Roelof

Arnold

2

0

 

You will see a 0 in the userlevel field for the last two people because they do not have records in compuser.

 

Sort order:  position level descending, competency name, user level, firstname, surname