i am inserting data into database , table below
Create table #tbl_Leaves (L_ID int,L_From_Date date,L_To_Date date,L_Days Decimal(3,1) )
Insert into #tbl_Leaves values (1001, '2021-06-01','2021-06-05',5)
Now when above Data inserted into table, then below Data also insert into second table ,
Note: if I am giving date from 01-06-2021 to 05-06-2021 ,then it auto separate date below like
Create table #tbl_Leaves_Details (ID int,L_ID int,L_Date date,L_qty int)
Insert into #tbl_Leaves_Details values (1 ,1001,'2021-06-01',1)
Insert into #tbl_Leaves_Details values (2 ,1001,'2021-06-02',1)
Insert into #tbl_Leaves_Details values (3 ,1001,'2021-06-03',1)
Insert into #tbl_Leaves_Details values (4 ,1001,'2021-06-04',1)
Insert into #tbl_Leaves_Details values (5 ,1001,'2021-06-05',1)