SQL Server 2022

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

CREATE TABLE [tblA](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](50) NULL,
    [Date] [date] NULL,
    [Val] [nvarchar](50) NULL
);


CREATE TABLE [tblDate](
    [Date] [date] NULL
) ;

SET IDENTITY_INSERT [tblA] ON ;


INSERT [tblA] ([Id], [Name], [Date], [Val])
VALUES
(3, N'A', CAST(N'2023-12-22' AS Date), N'data'),
(4, N'A', CAST(N'2023-12-23' AS Date), N'data'),
(5, N'B', CAST(N'2023-12-22' AS Date), N'data'),
(6, N'B', CAST(N'2023-12-23' AS Date), N'data'),
(7, N'A', CAST(N'2023-12-27' AS Date), N'data'),
(8, N'A', CAST(N'2023-12-28' AS Date), N'data');


SET IDENTITY_INSERT [tblA] OFF;

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-22' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-23' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-24' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-25' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-26' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-27' AS Date));

INSERT [tblDate] ([Date]) VALUES (CAST(N'2023-12-28' AS Date));
13 rows affected

SELECT * FROM tblA;
SELECT * FROM tblDate;


Id
Name
Date
Val


3
A
2023-12-22
data

4
A
2023-12-23
data

5
B
2023-12-22
data

6
B
2023-12-23
data

7
A
2023-12-27
data

8
A
2023-12-28
data




Date


2023-12-22

2023-12-23

2023-12-24

2023-12-25

2023-12-26

2023-12-27

2023-12-28


SELECT n.Name, d.[Date]
FROM tblDate d 
CROSS JOIN (SELECT DISTINCT Name FROM tblA) n
LEFT JOIN tblA a ON d.[Date] = a.[Date] AND a.Name = n.Name
WHERE a.Id IS NULL
ORDER BY [Date], Name


Name
Date


A
2023-12-24

B
2023-12-24

A
2023-12-25

B
2023-12-25

A
2023-12-26

B
2023-12-26

B
2023-12-27

B
2023-12-28

Id	Name	Date	Val
3	A	2023-12-22	data
4	A	2023-12-23	data
5	B	2023-12-22	data
6	B	2023-12-23	data
7	A	2023-12-27	data
8	A	2023-12-28	data

Name	Date
A	2023-12-24
B	2023-12-24
A	2023-12-25
B	2023-12-25
A	2023-12-26
B	2023-12-26
B	2023-12-27
B	2023-12-28