I would like to add a date range to this query as my SQL skills are limited.
Can someone help?
SELECT td.SESSION_LICENSE.SL_LICENSE_TYPE, Count(*) AS [License Counts]
GROUP BY td.SESSION_LICENSE.SL_LICENSE_TYPE;
If you search for SQL Syntax Date on the internet (through google.com for instance), there are many resources available to explain proper SQL syntax. For instance. http://www.tizag.com/sqlTutorial/sqlwhere.php
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)