Select Query for DatesEmpID,Name,PermissionDateFrom,PermissionDateTo,PermissionHours
From the above table content, I need to write a query that TestUser have permission the date 10-01-2014.
The Dates from jan 1 to Feb 7. So 10th of jan is between the dates.
I give input as 10Jan, it should fetch the above row. so i can get the 01:00 Hrs of permission as result.