title: Stored Procedure in SQl server 2008 to get sum of column of table and call it in controller in asp.net mvc3
body: <p>I am new to SQL- Server 2008</p>
  
  <p>I want to write a stored procedure to get sum of a column in table and display it in a single column.</p>
  
  <p>and I want to call this procedure in my controller of Asp.net Mvc3 and I am using C# language.</p>
  
  <p>I have a table like...</p>
  
  <p>Table Name: <code>EmployeeInfo</code></p>
  
  <pre><code>EmployeeName|MoneyGiven
  ------------------------
  001|2000
  002|300
  003|400
  001|200
  003|300
  002|400
  003|100
  </code></pre>
  
  <p>and I want the result as</p>
  
  <pre><code>EmployeeName|MoneyGiven
  ------------------------
  001|2200
  002|700
  003|800
  </code></pre>
  
  <p>How can I do this?</p>
  
  <p>Can anyone help me?</p>