SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (
    ID INT,
    INDX DATE
);

INSERT INTO table1 (ID, INDX)
VALUES
    (1, '2014-06-07'),
      (2, '2018-02-04')

CREATE TABLE table2 (
    ID INT,
    CODE VARCHAR(10),
    DAT DATE,
    QRTR INT
);

INSERT INTO table2 (ID, CODE, DAT, QRTR)
VALUES
    (1, 'A','2013-08-20', 20133),
    (1, 'A','2013-12-20', 20134),
    (1, 'A','2014-01-02', 20141),
    (1, 'A','2014-11-18', 20144),
    (1, 'A','2015-02-08', 20151),
    (1, 'A','2015-04-20', 20152), 
    (1, 'A','2015-11-16', 20154),
    (1, 'A','2016-04-12', 20162),
    (1, 'A','2017-01-20', 20171),
    (1, 'A','2017-12-12', 20174),
    (1, 'A','2018-01-03', 20181),
    (1, 'A','2019-05-20', 20193),
    (1, 'A','2020-01-01', 20201),
    (1, 'A','2021-04-16', 20212),
    (1, 'A','2021-08-20', 20213),
    (1, 'A','2021-12-30', 20214),
      (2, 'A','2017-12-12', 20174),
    (2, 'A','2018-01-03', 20181),
    (2, 'A','2019-05-20', 20193),
    (2, 'A','2021-08-20', 20213),
    (2, 'A','2021-12-30', 20214)

SELECT *
FROM Table1;
SELECT *
FROM Table2;

ID	INDX
1	2014-06-07
2	2018-02-04

ID	CODE	DAT	QRTR
1	A	2013-08-20	20133
1	A	2013-12-20	20134
1	A	2014-01-02	20141
1	A	2014-11-18	20144
1	A	2015-02-08	20151
1	A	2015-04-20	20152
1	A	2015-11-16	20154
1	A	2016-04-12	20162
1	A	2017-01-20	20171
1	A	2017-12-12	20174
1	A	2018-01-03	20181
1	A	2019-05-20	20193
1	A	2020-01-01	20201
1	A	2021-04-16	20212
1	A	2021-08-20	20213
1	A	2021-12-30	20214
2	A	2017-12-12	20174
2	A	2018-01-03	20181
2	A	2019-05-20	20193
2	A	2021-08-20	20213
2	A	2021-12-30	20214

ID	Year	IsQuarterly
1	2013	Yes
1	2014	Yes
1	2015	Yes
1	2016	Yes
1	2017	Yes
1	2018	Yes
1	2019	Yes
1	2020	Yes
1	2021	Yes
2	2013	No
2	2014	No
2	2015	No
2	2016	No
2	2017	Yes
2	2018	Yes
2	2019	Yes
2	2020	No
2	2021	Yes