Select rows into columns and show a flag in the column

Trying to get an output like the below:

| UserFullName | JAVA   | DOTNET | C      | HTML5  |
|--------------|--------|--------|--------|--------|
|     Anne San |        |        |        |        |
|   John Khruf |      1 |      1 |        |      1 |
|    Mary Jane |      1 |        |        |      1 |
|  George Mich |        |        |        |        |

This shows the roles of a person. A person could have 0 or N roles. When a person has a role, I am showing a flag, like '1'.

Actually I have 2 blocks of code:

Block #1: The tables and a simple output which generates more than 1 rows per person.

SQL Fiddle

MS SQL Server 2008 Schema Setup:

CREATE TABLE AvailableRoles 
(
  id int identity primary key, 
  CodeID varchar(5), 
  Description varchar(500), 
);

INSERT INTO AvailableRoles
(CodeID, Description)
VALUES
('1', 'JAVA'),
('2', 'DOTNET'),
('3', 'C'),
('4', 'HTML5');

CREATE TABLE PersonalRoles 
(
  id int identity primary key, 
  UserID varchar(100), 
  RoleID varchar(5), 
);

INSERT INTO PersonalRoles
(UserID, RoleID)
VALUES
('John.Khruf', '1'),
('John.Khruf', '2'),
('Mary.Jane', '1'),
('Mary.Jane', '4'),
('John.Khruf', '4');


CREATE TABLE Users 
(
  UserID varchar(20), 
  EmployeeType varchar(1),
  EmployeeStatus varchar(1),
  UserFullName varchar(500), 
);

INSERT INTO Users
(UserID, EmployeeType, EmployeeStatus, UserFullName)
VALUES
('John.Khruf', 'E', 'A', 'John Khruf'),
('Mary.Jane', 'E', 'A', 'Mary Jane'),
('Anne.San', 'E', 'A', 'Anne San'),
('George.Mich', 'T', 'A', 'George Mich');

Query 1:

SELECT
  A.UserFullName,
  B.RoleID
FROM
  Users A
LEFT JOIN PersonalRoles B ON B.UserID = A.UserID
WHERE
  A.EmployeeStatus = 'A'
ORDER BY
  A.EmployeeType ASC,
  A.UserFullName ASC

Results:

| UserFullName | RoleID |
|--------------|--------|
|     Anne San | (null) |
|   John Khruf |      1 |
|   John Khruf |      2 |
|   John Khruf |      4 |
|    Mary Jane |      1 |
|    Mary Jane |      4 |
|  George Mich | (null) |

Block #2: An attempt to convert the rows into columns to be used in the final result

SQL Fiddle

MS SQL Server 2008 Schema Setup:

CREATE TABLE AvailableRoles 
(
  id int identity primary key, 
  CodeID varchar(5), 
  Description varchar(500), 
);

INSERT INTO AvailableRoles
(CodeID, Description)
VALUES
('1', 'JAVA'),
('2', 'DOTNET'),
('3', 'C'),
('4', 'HTML5');

Query 1:

SELECT
  *
FROM
(
  SELECT CodeID, Description
  FROM AvailableRoles
) d
PIVOT
(
  MAX(CodeID)
  FOR Description IN (Java, DOTNET, C, HTML5)
) piv

Results:

| Java   | DOTNET | C     | HTML5  |
|--------|--------|-------|--------|
|      1 |      2 |     3 |      4 |

Any help in mixing both blocks to show the top output will be welcome. Thanks.