Hi Bhavesh23,

Use Common table expression.

SQL

CREATE TABLE #TempTable([Date] DATE,Record INT)
INSERT INTO #TempTable VALUES('2022/08/01', 10)
INSERT INTO #TempTable VALUES('2022/08/02', 11)
INSERT INTO #TempTable VALUES('2022/08/05', 12)
INSERT INTO #TempTable VALUES('2022/08/06', 13)
INSERT INTO #TempTable VALUES('2022/08/07', 14)

DECLARE @StartDate DATE, @EndDate DATE
SET @StartDate = '2022/08/02'
SET @EndDate = '2022/08/06'

;WITH CTE 
AS 
(
	SELECT @StartDate AS 'Date'
	UNION ALL
	SELECT DATEADD(DAY,1,[Date]) AS StartDate
	FROM CTE
	WHERE DATEADD(DAY,1,[Date]) <= @EndDate
)
SELECT *,ISNULL((SELECT Record FROM #TempTable WHERE [Date] = c.[Date]), '0') AS 'Record' FROM CTE c

DROP TABLE #TempTable

Output