title: sql server Ceate view as required
body: <p>I have 2 tables for a school fee management project<br>
  students table which has student name class and other fields<br>
  and tbl_fee_rates is the table which keep information about class fee on the basis of rates
  each month rate should be calculated using tbl_fee_rates table</p>
  
  <pre><code>tbl_fee_rates
  -------------------------------------
  id    date       class    rate      |
  -------------------------------------
  1   31-12-2013    5th     200       |
  2   31-12-2013    6th     500       |
                                      |
  3   27-03-2013    5th     250       |
  4   01-04-2013    6th     600       |
                                      |
  5   29-05-2013    5th     300       |
                                      |
  6   29-09-2013    5th     320       |
  -------------------------------------
  </code></pre>
  
  <p>and another table is </p>
  
  <pre><code>tbl_Students
  -----------------------
  ID     Name     Class |
  -----------------------
  1      Alex      5th  |
  1      Alex      6th  |
  -----------------------
  </code></pre>
  
  <p>I need a view as following</p>
  
  <pre><code>tbl_Students
  --------------------------------------------------------------------------------------
  ID     Name     Class  JAN   FEB   MAR   APR  MAY  JUN  JUL  AUG  SEP  OCT  NOV  DEC |
  --------------------------------------------------------------------------------------
  1      Alex      5th   200   200   200   250  250  300  300  300  300  320  320  320 |
  1      Alex      6th   500   500   500   500  500  500  500  600  600  600  600  600 |
  --------------------------------------------------------------------------------------
  </code></pre>
  
  <p>in above view jan,feb...dec are months and its values are fee of respective students
  for for a month is calculated using table(tbl_fee_rates)</p>
  
  <p>if it s not possible through, how can I get this, any alternative?</p>