SQL Server 2017

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

CREATE TABLE [dbo].[Table_TraineeInfo](
    [TraineeID] [int] NULL,
    [BatchId] [int] NULL,
    [Name] [varchar](max) NULL,
    [Mobile] [varchar](10) NULL
) ON [PRIMARY];

SET ANSI_PADDING OFF;

INSERT [dbo].[Table_TraineeInfo] ([TraineeID], [BatchId], [Name], [Mobile]) VALUES (243, 45, N'demo201', N'9888562341')
INSERT [dbo].[Table_TraineeInfo] ([TraineeID], [BatchId], [Name], [Mobile]) VALUES (244, 45, N'demo202', N'9888562342')
INSERT [dbo].[Table_TraineeInfo] ([TraineeID], [BatchId], [Name], [Mobile]) VALUES (246, 45, N'demo204', N'9888562344')
INSERT [dbo].[Table_TraineeInfo] ([TraineeID], [BatchId], [Name], [Mobile]) VALUES (247, 45, N'demo205', N'9999999999')
/****** Object:  Table [dbo].[Table_Batch_Lookup]    Script Date: 12/15/2019 04:34:41 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
CREATE TABLE [dbo].[Table_Batch_Lookup](
    [BatchId] [int] NULL,
    [BatchStartDate] [datetime] NULL,
    [BatchEndDate] [datetime] NULL
) ON [PRIMARY]
;
INSERT [dbo].[Table_Batch_Lookup] ([BatchId], [BatchStartDate], [BatchEndDate]) VALUES (45, CAST(0x0000AB2200000000 AS DateTime), CAST(0x0000AB25018B80D4 AS DateTime))
/****** Object:  Table [dbo].[Table_Attendance_Log]    Script Date: 12/15/2019 04:34:41 ******/
SET ANSI_NULLS ON
;
SET QUOTED_IDENTIFIER ON
;
SET ANSI_PADDING ON
;
CREATE TABLE [dbo].[Table_Attendance_Log](
    [TraineeID] [int] NULL,
    [BatchId] [int] NULL,
    [Attendance] [varchar](10) NULL,
    [l_date] [datetime] NULL
) ON [PRIMARY]
;
SET ANSI_PADDING OFF
;
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (243, 45, N'Present', CAST(0x0000AB220127842A AS DateTime))
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (243, 45, N'Present', CAST(0x0000AB2301281C2A AS DateTime))
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (243, 45, N'Present', CAST(0x0000AB240128E416 AS DateTime))
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (244, 45, N'Present', CAST(0x0000AB24012A05AB AS DateTime))
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (246, 45, N'Present', CAST(0x0000AB23012B245A AS DateTime))
INSERT [dbo].[Table_Attendance_Log] ([TraineeID], [BatchId], [Attendance], [l_date]) VALUES (246, 45, N'Present', CAST(0x0000AB24012B245A AS DateTime))

11 rows affected

Declare @cols NVARCHAR(Max)='';
Declare @select_cols NVARCHAR(Max)='';

;With log_date AS (
	SELECT BatchStartDate as l_date FROM Table_Batch_Lookup
	UNION ALL
	SELECT DATEADD(dd, 1, l_date)
	FROM log_date AS ld, Table_Batch_Lookup AS tb 
	WHERE ld.l_date < DATEADD(dd, -1, tb.BatchEndDate)
)
SELECT 
	@cols = COALESCE (
		@cols + ',[' + CONVERT(NVARCHAR,CONVERT(VARCHAR(10), l_Date, 111), 106) + ']',
		'[' + CONVERT(NVARCHAR, l_Date, 106) + ']'
	), 
	@select_cols = COALESCE (
		@select_cols 
			+ ',COALESCE([' + CONVERT(NVARCHAR,CONVERT(VARCHAR(10), l_Date, 111), 106) 
			+ '], ' + CASE WHEN CONVERT(DATE, l_Date, 111) <= GETDATE() THEN '''Absent''' ELSE '''NULL''' END + ') AS [' 
			+ CONVERT(NVARCHAR,CONVERT(VARCHAR(10), l_Date, 111), 106) + ']',
		'[' + CONVERT(NVARCHAR, l_Date, 106) + ']'
	)
FROM (SELECT DISTINCT CONVERT(VARCHAR(10), l_Date, 111) AS l_date FROM log_date) PV

Declare @totalScore INT =len(@cols) - len(replace(@cols, ',', ''))

DECLARE @query NVARCHAR(MAX); 
SET @query = 'SELECT t_info.TraineeID,t_batch.BatchId,t_info.Name,t_info.Mobile'+@select_cols+'
	FROM  Table_TraineeInfo AS t_info  
	LEFT JOIN (
			SELECT * FROM (
				 SELECT TraineeID,BatchId,Attendance,CONVERT(VARCHAR(10), l_Date, 111) AS l_date 
				 FROM Table_Attendance_Log
			) x
			PIVOT (
				 MAX(Attendance)
				 FOR l_Date IN (' + right(@cols, len(@cols)-1)+ ')
			) p 
	) AS f_pv ON t_info.TraineeID=f_pv.TraineeID 
	JOIN Table_Batch_Lookup as t_batch ON t_batch.BatchId=t_info.BatchId
	WHERE t_batch.BatchId=45';

EXEC SP_EXECUTESQL @query;

TraineeID	BatchId	Name	Mobile	2019/12/13	2019/12/14	2019/12/15	2019/12/16
243	45	demo201	9888562341	Present	Present	Present	Absent
244	45	demo202	9888562342	Absent	Absent	Present	Absent
246	45	demo204	9888562344	Absent	Present	Present	Absent
247	45	demo205	9999999999	Absent	Absent	Absent	Absent