I am using a stored procedure to return a date from a table. Is there a way to return a count of each individual day? In other words, how many times the date December 1, 2000 occurs, December 2, etc.<BR>Thanks for any help.
Well, you can use COUNT(myfield) in your SELECT statement. <BR>SELECT mydatefield, COUNT(mydatefield) AS recurring_date FROM mytable GROUP BY mydatefield<BR><BR>I use the AS to make it easier for ASP to get the counted field. Is this what you want to do?