I need to count how many are in each day. SO it needs to look like this
2012-11-08 BWM 5 Lucent_LTE 1
2012-11-09 BWM 3 Lucent_LTE 1
2012-11-10 BWM 5
2012-11-12 BWM 3
11-08-2012, 07:36 AM
gk53
THAT SQL WILL GIVE WHAT YOU NEED. IN MY CASE YOUR DATA IN #T TABLE
select distinct Event,Date_Start,
COUNT(Event) as evtNum
from #T
group by Event,Date_Start
