I should have 7 rows. I already have a query that my business partner always asks me to run to check on client volume by whatever he feels like it that day.

USE newCityCollection

SELECT CaseNumberKey, DateFinished

FROM PropertyInformation

WHERE DateFinished between '12/1/2012' AND '12/06/2012' AND ClientKey = 3

Results:

CaseNumberKeyDateFinished

0024282012-12-03 09:24:45.093

0024292012-12-03 12:32:29.687

0024302012-12-04 10:39:20.280

0024362012-12-04 10:43:55.640

0024382012-12-04 11:10:59.877

0024392012-12-04 12:11:24.377

0024402012-12-04 12:37:57.267