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, N'ravi', 200)
GO
INSERT [dbo].[emp] ([empid], [doj], [deptid], [ename], [sal]) VALUES (2, CAST(N'2017-01-08' AS Date), 20, N'banu', 300)
GO
INSERT [dbo].[emp] ([empid], [doj], [deptid], [ename], [sal]) VALUES (2, CAST(N'2017-01-07' AS Date), 20, N'banu', 250)
GO
INSERT [dbo].[emp] ([empid], [doj], [deptid], [ename], [sal]) VALUES (3, CAST(N'2017-01-10' AS Date), 30, N'jai', 400)
GO
based on above data I want data like below
empid |doj |deptid |ename |sal
1 |2017-01-02 |10 |ravi |100
1 |2017-01-03 |10 |ravi |100--missing dates need
1 |2017-01-04 |10 |ravi |100 --missing dates need
1 |2017-01-05 |10 |ravi |200
1 |2017-01-06 |10 |ravi |200-----missing dates need
2 |2017-01-07 |20 |banu |250
2 |2017-01-08 |20 |banu |300
2 |2017-01-09 |20 |banu |300----missing dates need
3 |2017-01-10 |30 |jai |400
please tell me how to write query to achive this task in sql server .