title: combine two records into one
body: <p>I've looked on here and there's a number of questions involving combining two records into one, but I think mine is a unique problem. 
  I have a software that uses sql queries to create desktop gadgets for our ticketing software. I want to track how many help desk tickets each technician has, and I have working code for that. It produces a bar graph that works great, however, sometimes multiple technicians or a technician and a manager are assigned to a ticket, and I can't extract that data. The code is:</p>
  
  <pre><code>SELECT TECHNICIAN, COUNT(TECHNICIAN) AS TICKETS
  FROM TABLE
  </code></pre>
  
  <p>(there's a bit of extra complexity with an inner join so I can get the employee's name on the bar graph by linking the employee's ID to the table with their actual names, but this is the simplified version)</p>
  
  <p>Here's my current result set:</p>
  
  <pre><code>TECHNICIAN    TICKETS
  Bob           5
  Bob, Harry    1
  Joe           6
  Mark          3
  Jeff          2
  </code></pre>
  
  <p>and the result set I  WANT is:</p>
  
  <pre><code>TECHNICIAN    TICKETS
  Bob           6
  Joe           6
  Mark          3
  Jeff          2
  </code></pre>
  
  <p>If the result set above goes into the gadget, it makes a bar for every record. So there would be a 'bob' bar and a 'bob, harry' bar. Also, I know that I only want technicians, so I don't need it to make a separate 'harry' record, just add both 'bob's together. ALSO, I have read-only access to the database, so creating new tables to hold the data is out.</p>
  
  <p>Thank you!</p>