Stackoverflow Question 1, Sql Server

Language: Layout:

CREATE TABLE Rubrique(
    ID int not null,
    Name varchar(max) not null,
    RubriqueA_ID int null,
    RubriqueB_ID int null
)
GO

CREATE TABLE BulletinRubrique(
    ID varchar(max) not null,
    EmployeID varchar(max) not null,
    RubriqueID int not null,
    Value float not null
)
GO

INSERT Rubrique VALUES(1, 'R1', 2, 3);
INSERT Rubrique VALUES(2, 'R2', 1, 2);
INSERT Rubrique VALUES(3, 'R3', null, null);
INSERT Rubrique VALUES(4, 'R4', null, 6);
INSERT Rubrique VALUES(5, 'R5', 6, null);
INSERT Rubrique VALUES(6, 'R6', null, 1);

INSERT BulletinRubrique VALUES('B1','EMP1', 1, 150);
INSERT BulletinRubrique VALUES('B1','EMP1', 2, 220);
INSERT BulletinRubrique VALUES('B1','EMP1', 3, 195);
INSERT BulletinRubrique VALUES('B1','EMP1', 4, 170);
INSERT BulletinRubrique VALUES('B1','EMP1', 5, 320);
INSERT BulletinRubrique VALUES('B1','EMP1', 6, 745);

SELECT t2.ID, t2.EmployeID, t2.RubriqueID, t2.Value, t2.A_Value, r2.Value AS B_value  FROM BulletinRubrique r2 
 RIGHT JOIN
   (
    SELECT t1.ID, t1.EmployeID, t1.RubriqueID, t1.Value, r1.VALUE AS A_VALUE, t1.B_VALUE  FROM BulletinRubrique r1 
      RIGHT JOIN ( 
        SELECT b.ID, b.EmployeID,b.RubriqueID, b.Value, r.RubriqueA_ID AS A_Value,  r.RubriqueB_ID AS B_Value
        FROM BulletinRubrique b RIGHT JOIN Rubrique r ON r.ID = b.RubriqueID ) t1 
      ON t1.A_Value =  r1.RubriqueID
   )t2 
      ON t2.B_Value =  r2.RubriqueID
      ORDER BY t2.RubriqueID
      GO

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 12, absolute service time: 0,19 sec