Best Answer · By JanBask MS SQL Server Expert
Answered on Mar 4, 2021
To get the dates between two dates you need to follow the accompanying cycle:
You need to place those two dates between single statements thusly:
SELECT Date, TotalAllowance
FROM Calculation
WHERE EmployeeId = 1 and Date between '2011/02/25' and '2011/02/27'