title: ISNULL() function requires two arguments? Simple solution
body: <p>I have misplaced something in the ISNULL() function and need another set of eyes to find it. I've stared at it so much I've become brainlocked (I know what ISNULL() is, this is just a simple syntax error)</p>
  
  <pre><code>(SELECT tn.teamtext, tn.teamid, ISNULL(sum(ISNULL(case when CONVERT(smalldatetime,dModLast,101) BETWEEN '2012-03-01' AND '2012-03-10' then 1 else 0 end), 0), 0) AS cnt3
    FROM teamnames AS tn 
      LEFT OUTER JOIN caseaudit AS ca
      ON tn.teamID = ca.referteamID2
    WHERE ca.referteamid1 &lt;&gt; ca.referteamid2 AND isactive = 1 AND groupid = 18 AND accountid = 2 AND referteamid1 = 31 AND auditnote &lt;&gt; 'Suspend Case'
    GROUP BY tn.teamtext, tn.teamid) AS c
  </code></pre>