test.sql

SELECT     TOP (100) PERCENT PartNum, CONVERT(DECIMAL(16, 4), CEILING(SUM(OurShipQty) * 2)) AS YearTotal, CONVERT(DECIMAL(16, 4), CEILING(SUM(OurShipQty) / 6)) 
                      AS MonthAvg, COUNT(PartNum) AS Hits
FROM         dbo.v_InvoiceRegisterForTurns
WHERE     (InvoiceDate > DATEADD(month, - 6, GETDATE())) AND (Plant = 'DIST') AND (InvoiceTerms NOT IN ('16', '26', '14', 'PORD', '50%D', '50%S')) AND (BuyToOrder = 'false' OR
                      BuyToOrder IS NULL)
GROUP BY PartNum