123123, Sql Server

Language: Layout:

CREATE TABLE TMP
    (
     Name VARCHAR(50)
    ,Data VARCHAR(10)
    ,Status VARCHAR(20)
    ,Count INT
    )
;
	
INSERT INTO TMP
	(Name, Data, Status,Count)
VALUES
	('A', '2017-06-01', 'ok',2),
	('A', '2017-06-01', 'error',5),
	('A', '2017-06-02', 'ok',3),
    ('A', '2017-06-02', 'error',1),
    ('A', '2017-06-03', 'ok',5),
    ('B', '2017-06-01', 'ok',2),
	('B', '2017-06-01', 'error',5),
	('B', '2017-06-02', 'ok',3),
    ('B', '2017-06-02', 'error',1),
    ('B', '2017-06-03', 'error',2)
;

DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
DECLARE @ColumnName AS NVARCHAR(MAX)

SELECT
    @ColumnName = ISNULL(@ColumnName + ',', '') + QUOTENAME(Name)
FROM
    ( SELECT DISTINCT
        Name
      FROM
        TMP
    ) AS Courses

SET @DynamicPivotQuery = N'
    SELECT Data, ' + @ColumnName + '
    FROM 
    (   SELECT 
	  t.Name, t.Data,
	  CONCAT(	 NULLIF(SUM(CASE WHEN t.Status = ''ok'' THEN t.Count ELSE 0 END),0),
			 ''/'', 
			 NULLIF(SUM(CASE WHEN t.Status = ''ok'' THEN 0 ELSE t.Count END),0)
		    ) AS Count
	   FROM dbo.TMP t
	   GROUP BY t.Name, t.Data
    ) src
    PIVOT
    (
	   MAX(Count)
        FOR Name IN (' + @ColumnName + ')
    ) AS PVTTable'

EXEC sp_executesql @DynamicPivotQuery

DROP TABLE dbo.TMP

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 10, absolute service time: 0,27 sec