title: Rollup function - Replace NULL
body: <p>I seem to be having trouble with the final pieces of my SQL. 
  When implementing the group by with roll up function within my SQL NULL appears. How can one modify NULL so that it is replaced with TOTAL within this aggregated SQL? </p>
  
  <pre><code>Current table returned
  Name Activate Deactivate
  Max      5       2
  TAX     12       5
  NULL    17       8
  
  select 
      case 
      when (upper(m.email) like '%max.com') then 'MAX'
      when (upper(m.email) like '%tax.com') then 'TAX'
      else 'OTHER'
  end Name, 
  SUM(case when substring(convert(varchar(8),n.created_on,112),1,6) = '201209' then 1 else 0         end) 'Activated',
     SUM(case when substring(convert(varchar(8),m.LastLockoutDate,112),1,6)='201209' then 1 else 0              end) 'Deactivated'
             from membership.user_details d
            inner join membership.aspnet_membership m 
  on m.userid = d.userid
          inner join membership.user_notes n 
           on n.userid = d.userid
          and n.CREATED_ON = (select min(created_on) 
                      from membership.user_notes 
                      where userid = n.userid
                          and note = 'received.')  
           where approved = 1
           group by case when (upper(m.email) like '%max.com') then 'MAX'
        when (upper(m.email) like '%tax.com') then 'TAX'
        else 'OTHER' end     
     with RollUp 
  </code></pre>