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
Microsoft SQL ServerMicrosoft SQL Server 2008
8/22/2022 - Mon
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!