Use this
where
clause:
WHERE [EmId] = @EmId AND CONVERT(DATE,[StartDate])= CONVERT(DATE,@StartDate) AND CONVERT(DATE,[EnDate]) = CONVERT(DATE,@EndDate)
When sql compares
datetime
objects, it includes the time component. I'm pretty sure you're only interested in comparing the date component, so you actually have to convert the compared datetimes to dates.