clai_shock008 - Thursday, March 8, 2018 3:21 AM
To group by date you'll definitely need to remove the time.
After reading your question properly, I'm not sure the error you're getting is actually because of the grouping. Have you declared any parameters to map to '?'?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537