SQL Server 2017

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

CREATE TABLE Appointments
(
    fromDate datetime,
    toDate   datetime,
    appointmentMode int
);

INSERT INTO Appointments VALUES
('20190919 11:00:00', '20190919 11:45:00', 0),
('20190919 11:35:00', '20190919 12:00:00', 1),
('20190919 11:00:00', '20190919 12:00:00', 2);
3 rows affected

DECLARE @CMD NVARCHAR(MAX);

SET @CMD = 'SELECT * INTO #T FROM Appointments; SELECT * FROM #T';

EXEC sp_executesql @CMD;


fromDate
toDate
appointmentMode


2019-09-19 11:00:00.000
2019-09-19 11:45:00.000
0

2019-09-19 11:35:00.000
2019-09-19 12:00:00.000
1

2019-09-19 11:00:00.000
2019-09-19 12:00:00.000
2


DECLARE @CMD2 NVARCHAR(MAX);

SET @CMD2 = 'SELECT * INTO ##T2 FROM Appointments;';

EXEC sp_executesql @CMD2;

SELECT * FROM ##T2;


fromDate
toDate
appointmentMode


2019-09-19 11:00:00.000
2019-09-19 11:45:00.000
0

2019-09-19 11:35:00.000
2019-09-19 12:00:00.000
1

2019-09-19 11:00:00.000
2019-09-19 12:00:00.000
2

fromDate	toDate	appointmentMode
2019-09-19 11:00:00.000	2019-09-19 11:45:00.000	0
2019-09-19 11:35:00.000	2019-09-19 12:00:00.000	1
2019-09-19 11:00:00.000	2019-09-19 12:00:00.000	2