title: how to Replace null with zero in pivot SQL query
body: <p>I am trying to fetch Year wise and month wise sales like </p>
  
  <pre><code> select * from
   (
   select year(InvDt) as [Year], left(datename(Month,InvDt), 3) as [Month], 
   InvAmnt as Amount
   from tblInvoice where TenantId =-xxxxxxxx
   ) as Inv
   pivot
   (sum(Amount) for [Month] in(Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, 
    Oct, Nov, [Dec])) as pvt
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Fg4xH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fg4xH.png" alt="enter image description here"></a>
  But here so many null is coming so I want to replace these null with zero.
  please help me.</p>