EmpID EmpName DateOFJoin DateOfLeaving Status 1 XYZ 2015-10-01 2017-09-26 De-Active 2 ABC 2018-01-01 Active 3 XYZ 2018-10-15 Active
EmpID EmpName DateOFJoin DateOfLeaving Status 2 ABC 2018-01-01 Active 3 XYZ 2018-10-15 Active
FromDate
ToDate
'2017-08-01'
'2017-09-30'
EmpID EmpName DateOFJoin DateOfLeaving Status 1 XYZ 2015-10-01 2017-09-26 De-Active
'2018-01-01'
'2018-03-31'
EmpID EmpName DateOFJoin DateOfLeaving Status 2 ABC 2018-01-01 Active
SELECT EmpID, EmpName, DateOFJoin, DateOfLeaving, Status FROM YourTable WHERE (DateOFJoin BETWEEN @FromDate AND @ToDate) OR (DateOfLeaving BETWEEN @FromDate AND @ToDate)
@FromDate
@ToDate
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)