SQL Pivot Table Query

Hi

Please try Below code ,

SELECT TYPE,
    MAX(CASE WHEN DATE = '2020-01-01' THEN TIME ELSE NULL END) AS '01-01-2020',
    MAX(CASE WHEN DATE = '2020-01-02' THEN TIME ELSE NULL END) AS '02-01-2020',
    MAX(CASE WHEN DATE = '2020-01-03' THEN TIME ELSE NULL END) AS '03-01-2020',
    MAX(CASE WHEN DATE = '2020-01-04' THEN TIME ELSE NULL END) AS '04-01-2020',
    MAX(CASE WHEN DATE = '2020-01-05' THEN TIME ELSE NULL END) AS '05-01-2020',
    MAX(CASE WHEN DATE = '2020-01-06' THEN TIME ELSE NULL END) AS '06-01-2020',
    MAX(CASE WHEN DATE = '2020-01-07' THEN TIME ELSE NULL END) AS '07-01-2020'
FROM MY_TABLE
GROUP BY TYPE;

 

First create a view which will show min and max time of dates and then use pivort on the view.

CREATE VIEW view_ViewName AS
	SELECT [DATE], 
		   [TYPE], 
	       [TIME] = CASE 
					    WHEN [TYPE] = 'A' THEN MIN([TIME]) 
					    ELSE MAX([TIME]) 
				    END 
      FROM [sampleTable]
  GROUP BY [DATE], [TYPE]

SELECT * FROM (
	SELECT [TYPE], [DATE], [TIME]
	  FROM [view_ViewName]
) Results
PIVOT (
	MAX([TIME]) FOR [DATE]
	IN ([2023-03-01],[2023-03-02],[2023-03-03])
) AS PivotTable