title: Union, Join, Or GroupBy
body: <p>I have procedures pulling data from various sources to give me 3 VERY similar tables.</p>
  
  <pre><code>Metric          | Tickets   |Band
  ______________________________________
  Acknowledgement | 45        | New
  Acknowledgement | 23        | Within
  Acknowledgement | 16        | Near
  Acknowledgement | 2         | Very Near
  </code></pre>
  
  <p>And</p>
  
  <pre><code>Metric     | Tickets   |Band
  ___________________________________
  Escalation | 10        | New
  Escalation | 43        | Within
  Escalation | 81        | Near
  Escalation | 6         | Very Near
  </code></pre>
  
  <p>And</p>
  
  <pre><code>Metric| Tickets   |Band
  ___________________________________
  Fixed | 34        | New
  Fixed | 52        | Within
  Fixed | 36        | Near
  Fixed | 4         | Very Near
  </code></pre>
  
  <p>Now, I would like to combine them together in some way to have one table output like this</p>
  
  <pre><code>Metric          | New   | Within | Near | Very Near
  _____________________________________________________
  Acknowledgement | 45    | 23     | 16   | 2
  Escalation      | 10    | 43     | 81   | 6
  Fixed           | 34    | 52     | 36   | 4
  </code></pre>
  
  <p>How can I achieve this in MS SQLServer, please ?</p>