In your example you are disassociating your dates with the error codes. This leads me to believe that you only care about a date range for selection purposes. This means you don't need to display your dates this way as it does not help you. I know 'how' you want the output to look but I'd be doing you a disservice if I helped you do that. What I was looking for is an explanation of what you are trying to get from your data so that I might propose a better solution.

For example It might be more useful to you to do something like this. You select your data based on your desired date range and then get a breakdown of the backend errors by ITG which occurred during that time frame. This is just a simple example of one possible way to dissect the data. My example can also be easily converted to Dynamic SQL to allow for more flexibility with errors codes. However, before I delve into that topic I'd like more descriptive feedback from you.

Hope this helps,

DECLARE @ITGDaillyMetrics TABLE (

ITG varchar (max),

Backenderror int,

dates date )

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',10,'26 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',20,'26 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',30,'26 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',40,'26 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',50,'26 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',10,'25 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',20,'25 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',30,'25 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',40,'25 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',50,'25 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',20,'24 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',30,'24 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',40,'24 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',50,'24 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',10,'24 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',30,'23 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',40,'23 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',50,'23 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',10,'23 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',20,'23 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',30,'22 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',40,'22 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',50,'22 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',10,'22 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',20,'22 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG01 - XFINITY Username and Password Reset',10,'21 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG02 - XFINITY Username and Password Reset',30,'21 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG03 - XFINITY Username and Password Reset',30,'21 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG04 - XFINITY Username and Password Reset',50,'21 Sep 2016')

insert into @ITGDaillyMetrics values ('ITG05 - XFINITY Username and Password Reset',20,'21 Sep 2016')

--SELECT * FROM @ITGDaillyMetrics

DECLARE @fromDate DATE = '20160901'

DECLARE @toDate DATE = '20160930'

SELECT

ITG,

SUM(CASE WHEN Backenderror = 10 THEN 1 ELSE 0 END) AS 'Error 10',

SUM(CASE WHEN Backenderror = 20 THEN 1 ELSE 0 END) AS 'Error 20',

SUM(CASE WHEN Backenderror = 30 THEN 1 ELSE 0 END) AS 'Error 30',

SUM(CASE WHEN Backenderror = 40 THEN 1 ELSE 0 END) AS 'Error 40',

SUM(CASE WHEN Backenderror = 50 THEN 1 ELSE 0 END) AS 'Error 50'

FROM @ITGDaillyMetrics

WHERE dates >= @fromDate AND dates <= @toDate

GROUP BY ITG