Calculated missing dates and fill missingdates with previous dates data in sql server

[klllmmm]

You may check below quiz & its reply. Looks like very similar to ur quiz.

Missing dates fill with previous date data in sql server

hi I have one doubt in sql server . how to fill missing dates related data with previous date related data in sql server table : emp CREATE TABLE [dbo].[emp]( [empid] [int] NULL, [doj] [date] NULL, [deptid] [int] NULL, [ename] varchar NULL, [sal] [int] NULL ) INSERT [dbo].[emp] ([empid], [doj], [deptid], [ename], [sal]) VALUES (1, CAST(N'2017-01-02' AS Date), 10, N'ravi', 100) GO INSERT [dbo].[emp] ([empid], [doj], [deptid], [ename], [sal]) VALUES (1, CAST(N'2017-01-05' AS Date), 10,…