i want to know the start bi-week and end bi-week dates.
create table #temp(EmployeeID int,TEDate datetime,EmpFNamenvarchar(100),EmpLName nvarchar(100))
go
insert into #temp (EmployeeID ,EmpFName,EmpLName,TEDate) Select 2019,'roz','Ahmad','2019-04-23' union all Select 2019,'roz','Ahmad','2019-04-17' union all Select 2019,'roz','Ahmad','2019-04-29' select * from #temp