I have a Date field which displays date per ID. I want to aggregate the dates by month and count the number of visits per ID. The output should look like this:
MONTH # OF CUST # OF VISITS
JAN 45 5
FEB 67 8
MAR 32 10
APR 18 21
.
.
.
I am assuming miltiple counts to be displayed on a single row would require multiple queries writing the output to one temp table for the final display.
But I don't know from a date field - how do I create a range. The values in the date field have pure dates (E.g. 2002-06-07 11:51:08.827)
