试试这个:-

  SELECT M.Months  AS MonthSold,D.QtySold as QtySold

  FROM (  SELECT distinct(MONTH(sd.SBINDT))as Months from dbo.SalesData sd)M
  left join 
    (
           SELECT MONTH(sd.SBINDT) AS MonthSold,SUM(sd.SBQSHP) AS QtySold
           FROM dbo.SalesData sd
     WHERE  sd.SBTYPE = 'O'
       AND sd.SBITEM = @Part
       AND YEAR(sd.SBINDT) = @Year
       AND sd.DefaultLocation = @Location
   GROUP BY MONTH(sd.SBINDT)
   )D
ON M.Months = D.MonthSold