You could try

SELECT DISTINCT MM.managerName,

  SD.scoreCardName,

  SUM(CASE MG.measurementId WHEN 1 THEN MG.goalValue END) AS A,

     SUM(CASE MG.measurementId WHEN 4 THEN MG.goalValue END) AS B,

     SUM(CASE MG.measurementId WHEN 5 THEN MG.goalValue END) AS...

We're having similar problems - the subscription errors out with Failure sending mail:.....  The Win32 error code that I'm seeing in our log files is 1355, which according to the...