title: How to count column values in table row?
body: <p>In SQL Server, i have one table in that there 15 columns are there, the columns contain the data <code>SL</code>,<code>PL</code>,<code>CL</code> or <code>8</code>,<code>4</code> like that.</p>
  
  <pre><code>empid  D1    D2 D3   D4  D5  D6  D7 D8 D9  D10 D11 D12 D13 D14 D15   
  ==================================================================
   sam   PL    8  PL   4   8   SL  8  SL 4   CL  8   CL  8    8   8 
   sunny 8     CL 4    CL  SL  8   4  SL 4   PL  8    8  8    8   8 
   zimmy 4     4  4    8   8   8   4  4  8   8   8    8  8    8   8 
  </code></pre>
  
  <p>Like the above my table is there , now i want to calculate PL or CL or SL of every empid, please help me.               </p>