Keeping An Accurate Count Of Events

I am newish to databases and would appreciate some
advise.
  I think I have a solution to my
problem but it is going to take me a lot of time to get it running.
  If there is a better way of doing it I would
like to know. 

I have a table :-






 â€œeventDatesâ€? with
columns (id,
date,
eventID,
eventCount)







The id auto increments as a Primary Key.


date holds the date of the
event.


EventID references another
table with info about the events

Up to 9
eventIDs can be added
for each date and I want eventCount to hold an integer (1 to 9) to allow me to “pivot�
the data to the table below




“results� with columns (
date,
eventCount1, eventCount2 …..eventCount9) so each row will hold a date and non
to nine
eventIDs occurring on that date.





Is there an easy way to keep eventCount accurate or do I
just have to write a lot of code?
  I
will need to be able to remove events as well as add them.
  I will use a mixture of stored procedures
and VB.Net I guess?





Many thanks for any advice.






Mike