Hi Thom A,

Do you mean the Create script for the table hosting the data?

if so please see below:

/****** Object: Table [dbo].[CALLSTATUSLOGGING]  Script Date:...

hi guys,

thanks a lot for your help. I have now went through the steps on how to get the dat ain a proper way to you and i...

Hi Thom A,

my data look slik ebelow:

CALLSTATID,CLIENTNO,CALLLOGID,CPGNO,CALLSTATE,LOCALISEDCALLSTATE,STATETIMEAGT,USEDBYAGENT,LOGAGENTNO,CALLLOGREF,COMPLETECODE,CTI_USER
1,1,10,5,Talking,Call time,08:27:38,agent1,123,NULL,NULL,70002
2,1,10,5,Hold,Hold,08:30:36,agent1,123,NULL,NULL,70002
3,1,10,5,Talking,Call time,08:34:17,agent1,123,NULL,NULL,70002
4,1,10,5,Hold,Hold,08:34:18,agent1,123,NULL,NULL,70002
5,1,10,5,Talking,Call time,08:34:52,agent1,123,NULL,NULL,70002
6,1,10,5,WrapUp,Wrap Time,08:36:19,agent1,123,NULL,NULL,70

Thanks for your answer. Actually what I am trying to do is to calculate the average time of each agent in a given state of a call. each agent state...

I need to create an sql which will generate a report on average time for agents where I work and I ma a bit stuck as per where to start...