title: Creating multiple columns from one column
body: <p>My database is structured like this:</p>
  
  <pre><code>Number | Month | Country
  ------------------------
  63     | June  | Ireland
  48     | June  | England
  55     | June  | Spain
  66     | May   | Ireland
  33     | May   | England
  53     | May   | Spain
  44     | April | Ireland
  44     | April | England
  44     | April | Spain
  </code></pre>
  
  <p>I want to use an SQL statement to call this from the data above. Can anyone help me out please. Basically I want to split the number column into multiple other columns according to the month associated with it. I'm using sql-server 2000</p>
  
  <pre><code>Country | June | May | April
  ---------------------------
  Ireland | 63   | 66  |  44
  England | 48   | 33  |  44
  Spain   | 55   | 53  |  44
  </code></pre>