Query to Group by Company and quantity by month

Try this.

CREATE TABLE [dbo].[DM_SP_SHIP]
(
          PharmacyName VARCHAR(30)
        , ShipDate        DATE
        , Quantity        INT
)

INSERT INTO [dbo].[DM_SP_SHIP]
VALUES
('Company1',    '2014-04-01',   3),
('Company1',    '2014-04-02',   4),
('Company1',    '2014-04-03',   5),
('Company1',    '2014-05-10',   3),
('Company1',    '2014-05-11',   7),
('Company1',    '2014-05-12',   5),
('Company1',    '2014-06-22',   1),
('Company1',    '2014-06-23',   2),
('Company1',    '2014-06-24',   3),
('Company2',    '2014-04-01',   3),
('Company2',    '2014-04-02',   4),
('Company2',    '2014-04-03',   5),
('Company2',    '2014-05-10',   3),
('Company2',    '2014-05-11',   7),
('Company2',    '2014-05-12',   5),
('Company2',    '2014-06-22',   1),
('Company2',    '2014-06-23',   2),
('Company2',    '2014-06-24',   3),
('Company3',    '2014-04-01',   3),
('Company3',    '2014-04-02',   4),
('Company3',    '2014-04-03',   5),
('Company3',    '2014-05-10',   3),
('Company3',    '2014-05-11',   7),
('Company3',    '2014-05-12',   5),
('Company3',    '2014-06-22',   1),
('Company3',    '2014-06-23',   2),
('Company3',    '2014-06-24',   3)

SELECT
    PharmacyName
  , ISNULL(CAST((DATENAME(MONTH, [SHIPDATE]) + ' ' + CAST(DATEPART(Year, [SHIPDATE]) as VARCHAR(4))) as VARCHAR(20)) , 'No Date') as [Month]
  , SUM(Quantity) as Quantity
FROM [dbo].[DM_SP_SHIP]
GROUP BY 
    PharmacyName
  , ISNULL(CAST((DATENAME(MONTH, [SHIPDATE]) + ' ' + CAST(DATEPART(Year, [SHIPDATE]) as VARCHAR(4))) as VARCHAR(20)) , 'No Date')
ORDER BY 1

Abhi.

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you