Miscellany

Select cd.Date, cd.Hour, cd.CampaignName 

, sum(Attempts) Dials, Sum(Connects) Voice, sum([Total Time]) TotalTOS

	, sum([Not Ready]) NotReady, sum([Other Time]) Talk

	, ((sum([Total Time]) - sum([Not Ready]))/3600) as Agents

	, (sum([Total Time]) - sum([Not Ready]))/100 as TOS

	, (sum(ReadyTime))as Idle

	, sum(Attempts)/((sum([Total Time]) - sum([Not Ready]))/3600) as AttemptsByAgents

	, sum(DA) as DeadAir

	, sum(CallsHandledHalf) as CallsHandled

	, sum(CallsOfferedHalf) as CallsOffered

	, (sum([Other Time])/sum(CallsHandledHalf)) as AHT

	, left(Round(AbandRt*100,2),5) as AbandRate



from Campaign_Data cd 

left outer join Skill_Data sd

	on cd.CampaignName= sd.CampaignName 

	and cd.DateTime = sd.DateTime

--left outer join term_Data d

--	on  DATEPART(DAY,cd.DateTime) = DATEPART(DAY,d.DateTime)

	--and DATEPART(hour,cd.DateTime) = DATEPART(hour,d.DateTime)

--	on cd.CampaignName= d.CampaignName 

--	and cd.Date = d.Date

	--and cd.Hour = d.Hour

left outer join Call_Data b

	on cd.CampaignName= b.CampaignName 

	and cd.DateTime = b.DateTime





group by cd.Date, cd.Hour, cd.CampaignName , AbandRt

Having (sum([Total Time]) - sum([Not Ready]))/3600 > 0 and (sum(CallsHandledHalf))>0