i have a column called RentDate.
I want to get all info that happened the previous day, no matter what time it happened the previous day.
So no matter when i run the query, it need to show me the previous day info.
The query below gives me the correct info, but I know I could do something different for RentDate:
select customernbr, storenbr, toolnbr, count(toolnbr)
where RentDate '2015-07-29 22:00:21.427'
and StoreNbr = '01101' and customernbr = '02001020'
group by CustomerNbr, storenbr, toolnbr