By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH TableA AS (
SELECT '2019-01-01' AS Date UNION ALL
SELECT '2019-02-01' UNION ALL
SELECT '2019-03-01' UNION ALL
SELECT '2019-04-01'
),
TableB AS (
SELECT 'AABB' AS UniqueId UNION ALL
SELECT 'BCCC' UNION ALL
SELECT 'FGGG'
)
SELECT
b.UniqueId,
a.Date
FROM TableA a
CROSS JOIN TableB b
ORDER BY
b.UniqueId,
a.Date;
| UniqueId | Date |
|---|---|
| AABB | 2019-01-01 |
| AABB | 2019-02-01 |
| AABB | 2019-03-01 |
| AABB | 2019-04-01 |
| BCCC | 2019-01-01 |
| BCCC | 2019-02-01 |
| BCCC | 2019-03-01 |
| BCCC | 2019-04-01 |
| FGGG | 2019-01-01 |
| FGGG | 2019-02-01 |
| FGGG | 2019-03-01 |
| FGGG | 2019-04-01 |