I have gotten this far, I have the calls separated by the spaces. Now it's joining on the contacts phone number.

Just wanted to comment, I had same problem and this worked like a charm....Thanks

I am not sure where it went. Here it is again

Just curious could I create a lookup table with all the extension in it and then insert that into the CallTrace table where the extension and do the same for...

Here's the file being processed.

Yes that is what I am reporting on, for each extension. The count of incoming and out going call for each extension displaying customer contact and call duration.

I don't need all of the data, I am inserting the data from my original post to create a SSRS report, the data is coming from the flatfile which I...

Tell me about it I have told them before any projects are started the data needs cleaned up, these tables don't even have Pk or fk, they b Ave...

I will give this a try in a little while, I appreciate all that have stuck through this post. I will mark answered if this is a solution or even...

No I figured I would get the tsql working first, and then attempt that change.

No...just as I posted it..

Ok, that ran, but it is terribly slow, The function from Jeff returned the data fast, although within characters it put the counts in one row, and would like to...

I can't put a where clause on this, before the cross apply?? It gives an error incorrect syntax before cross???

if OBJECT_ID('AA_Helper.dbo.MitelCallTrace') is not null

drop table AA_Helper.dbo.MitelCallTrace

create table AA_Helper.dbo.MitelCallTrace

(

calldata varchar(400)

)

INSERT INTO...

Jeff your code actually did the trick, now I have to get each value into a different columns, you have them concatenated together, but this is a great start..

It actually gave me the count of chars, before the first space...CharIndex has only given me the count of spaces within the string.