CREATE TABLE #tempData ( [Year] INT ,[Date] DATE ,PValue FLOAT ) INSERT INTO #tempData Values(2019,'10/31/2019',95.5) INSERT INTO #tempData Values(2019,'11/30/2019',96.6) INSERT INTO #tempData Values(2019,'12/31/2019',94.4) INSERT INTO #tempData Values(2020,'11/30/2020',89.8) INSERT INTO #tempData Values(2020,'12/31/2020',90.1) INSERT INTO #tempData Values(2021,'11/30/2021',92.3) INSERT INTO #tempData Values(2021,'12/31/2021',92.5) INSERT INTO #tempData Values(2022,'06/30/2022',96.6) INSERT INTO #tempData Values(2022,'07/31/2022',98.9) SELECT * FROM #tempData DROP TABLE IF EXISTS #tempData;