Как перенести строки в столбец в TSQL?

Сценарий (указанный ниже) дает результат (см. снимок экрана 01)Снимок экрана 01. результат должен отображаться как (см. screenshot02)Screenshot02.

Дата в work_date (см. снимок экрана 01) должна отображаться в виде отдельного столбца даты, а часы в work_hour (см. снимок экрана 01) должны отображаться в отдельном столбце даты.

DECLARE @01_STARTDATE VARCHAR(100);
DECLARE @02_ENDDATE VARCHAR(100);
DECLARE @STAFF INT;

SET @01_STARTDATE = '2017-07-06';
SET @02_ENDDATE = '2017-07-10';
SET @STAFF = 8;

SELECT   
    @01_STARTDATE + ' - ' + @02_ENDDATE AS [Date Range],
    SU.FIRST_NAME + ' ' + SU.LAST_NAME AS Staff,
    f.FACILITY_NAME AS Site_Name,
    P.PRJ_PROJECT_NAME AS Project_Name,
    R.PROJECT_TYPE_NAME AS Project_Type_Brownfield,
    '' AS Project_Type_VRP,
    st.work_hour, st.work_date
FROM 
    FAC_FACILITY AS f
INNER JOIN 
    GOV.PRJ_PROJECT AS P ON f.FACILITY_RID = p.FACILITY_RID
INNER JOIN 
    GOV.SYS_TIME_LOG AS ST ON ST.PRJ_PROJECT_RID = P.PRJ_PROJECT_RID
LEFT JOIN 
    SEC_USER AS SU ON SU.USER_RID = ST.USER_RID
LEFT JOIN 
    GOV.REF_PROJECT_TYPE AS R ON P.PROJECT_TYPE_RID = R.PROJECT_TYPE_RID
WHERE 
    ST.WORK_DATE BETWEEN CAST(@01_STARTDATE AS DATE) AND CAST(@02_ENDDATE AS DATE)
    AND ST.USER_RID = @STAFF        
    AND R.PROJECT_TYPE_RID = 3
GROUP BY 
    f.FACILITY_NAME, P.PRJ_PROJECT_NAME, SU.FIRST_NAME,
    st.work_date, SU.LAST_NAME, R.PROJECT_TYPE_NAME,
    st.work_hour

UNION ALL

SELECT   
    @01_STARTDATE + ' - ' + @02_ENDDATE AS [Date Range],
    SU.FIRST_NAME + ' ' + SU.LAST_NAME AS Staff,
    f.FACILITY_NAME AS Site_Name,
    P.PRJ_PROJECT_NAME AS Project_Name,
    '' AS Project_Type_Brownfield,
    R.PROJECT_TYPE_NAME AS Project_Type_VRP,
    st.work_hour, st.work_date
FROM
    FAC_FACILITY AS f
INNER JOIN 
    GOV.PRJ_PROJECT AS P ON f.FACILITY_RID = p.FACILITY_RID
INNER JOIN 
    GOV.SYS_TIME_LOG AS ST ON ST.PRJ_PROJECT_RID = P.PRJ_PROJECT_RID
LEFT JOIN 
    SEC_USER AS SU ON SU.USER_RID = ST.USER_RID
LEFT JOIN 
    GOV.REF_PROJECT_TYPE AS R ON P.PROJECT_TYPE_RID = R.PROJECT_TYPE_RID
WHERE 
    ST.WORK_DATE BETWEEN CAST(@01_STARTDATE AS DATE) AND CAST(@02_ENDDATE AS DATE)
    AND ST.USER_RID = @STAFF        
    AND R.PROJECT_TYPE_RID = 2
GROUP BY 
    f.FACILITY_NAME, P.PRJ_PROJECT_NAME, SU.FIRST_NAME,
    st.work_date, SU.LAST_NAME, R.PROJECT_TYPE_NAME,
    st.work_hour

UNION ALL

SELECT   
    @01_STARTDATE + ' - ' + @02_ENDDATE AS [Date Range],
    SU.FIRST_NAME + ' ' + SU.LAST_NAME AS Staff,
    g.grant_name AS Site_Name,
    '' AS project_name,
    '' AS Project_Type_Brownfield,
    '' AS Project_Type_VRP,
    st.work_hour, st.work_date
FROM
    (SELECT 
         SUM(work_hour) AS work_hour, user_rid,
         grant_rid, work_date
     FROM  
         GOV.SYS_TIME_LOG
     WHERE 
         WORK_DATE BETWEEN CAST(@01_STARTDATE AS DATE) AND CAST(@02_ENDDATE AS DATE)
         AND USER_RID = @STAFF        
         AND grant_rid = 1
     GROUP BY 
         grant_rid, user_rid, work_date) AS ST
LEFT JOIN 
    SEC_USER AS SU ON SU.USER_RID = ST.USER_RID
LEFT JOIN 
    SYS_GRANT AS G ON st.grant_rid = g.grant_rid
WHERE 
    ST.WORK_DATE BETWEEN CAST(@01_STARTDATE AS DATE) AND CAST(@02_ENDDATE AS DATE)
    AND ST.USER_RID = @STAFF        
    AND st.grant_rid = 1
GROUP BY 
    SU.FIRST_NAME, st.work_date, SU.LAST_NAME,
    G.Grant_name, st.work_hour;