title: Remove Nulls from Select in a Select
body: <p>I am using a query to total hours week over week by employee. I use a select within a select to separate the weeks into columns. I am receiving Nulls for some employees. How can I remove the Nulls</p>
  
  <pre><code>select distinct
  EM.EMPLOYEE,
  RTRIM(LTRIM(LAST_NAME))+', '+RTRIM(LTRIM(FIRST_NAME)) as [FULL NAME],
  (Select SUM(ISNULL(HOURS,'0')) from TimeTbl PT2 WHERE DATEPART(WK, Date) = DATEPART(WK, DATEADD(WK, -1, getdate())) and PAYROLL_YEAR='2020'and PT2.EMPLOYEE=PT.EMPLOYEE) AS [WEEK 1 HOURS],
  (Select SUM(ISNULL(HOURS,'0')) from TimeTbl  PT2 WHERE DATEPART(WK, Date) = DATEPART(WK, DATEADD(WK, -2, getdate())) and PAYROLL_YEAR='2020'and PT2.EMPLOYEE=PT.EMPLOYEE) AS [WEEK 2 HOURS],
  (Select SUM(ISNULL(HOURS,'0')) from TimeTbl  PT2 WHERE DATEPART(WK, Date) = DATEPART(WK, DATEADD(WK, -3, getdate())) and PAYROLL_YEAR='2020'and PT2.EMPLOYEE=PT.EMPLOYEE) AS [WEEK 3 HOURS],
  (Select SUM(ISNULL(HOURS,'0')) from TimeTbl  PT2 WHERE DATEPART(WK, Date) = DATEPART(WK, DATEADD(WK, -4, getdate())) and PAYROLL_YEAR='2020' and PT2.EMPLOYEE=PT.EMPLOYEE)AS [WEEK 4 HOURS],
  (Select SUM(ISNULL(HOURS,'0')) from TimeTbl  PT2 WHERE DATEPART(WK, TR_DATE) = DATEPART(WK, DATEADD(WK, -5, getdate())) and PAYROLL_YEAR='2020' and PT2.EMPLOYEE=PT.EMPLOYEE)AS [WEEK 5 HOURS]
  From TimeTbl  PT
  right join EMPLYTBL EM on PT.EMPLOYEE=EM.EMPLOYEE
  </code></pre>