Select a.Month, a.Date, a.Hour, a.CampaignName 

, a.Dials, a.Voice,a.TOS, sum(b.DA)

from term_data b, 

(select DATEPART(Month,sd.DateTime) Month, DATEPART(DAY,sd.DateTime) Date,DATEPART(Hour,sd.DateTime) Hour,

	sd.CampaignName,

	sum(Attempts) Dials, Sum(Connects) Voice, sum([Total Time]) TOS, sum([Other Time]) Talk





from Campaign_Data cd , Skill_Data sd

where cd.CampaignName= sd.CampaignName 

--and cd.CampaignName = td.CampaignName

and sd.DateTime = cd.DateTime

--and sd.DateTime = td.DateTime

group by DATEPART(Month,sd.DateTime), DATEPART(DAY,sd.DateTime),DATEPART(Hour,sd.DateTime), sd.CampaignName

) a

where 

a.CampaignName = b.CampaignName

and a.Date = DATEPART(DAY,b.DateTime)

and a.Hour = DATEPART(hour,b.DateTime)

group by a.Month, a.Date, a.Hour, a.CampaignName,  a.Dials, a.Voice,a.TOS

order by a.CampaignName ,a.Month, a.Date, a.Hour