Copy one SQL data dump to another table

Dump the all data into another table

insert into dbo.LeaveDetails(EmpId,LeaveTypeId,FromDate,ToDate)

select EmpId,1,WorkedDate,TakenDate from dbo.CompensatoryDetails