Yes, thats what I did, the select into the temp table is what takes the time, running the query on the temp table is milli seconds......thanks again, still awaiting the...

Output to grid, and I am using a view that includes around 48 individual tables...

Both work, but yes, improved.....now I just need to spend the time to figure it all out....:-)

BTW, it works perfect on my 20,000 + rows, took 7 seconds total.....

Is there...

That is exactly what I needed! Thanks. I will set this up and see if the user agrees.......

This report will be attached to an email from the sql server and sent to the user....(big company issues...don't ask...LOL).

So its my only option for now......

Can you give me a...

Thats pretty close..!

here is the output..

000000002 20110608 5098544444 ...

Craig,

This is woking really well! I am going to present a report to the facility today based on last nights activities, and hopefully get these guys in line. ...

They are allowed to dial international, but this routine can ignore those, as they do not typically dial international, so yes, all North American numbers start with a 2 thru...

Here is an actual sample table with real data from the person committing the fraud: (I did change the area code to protect the innocent..)

This is a specific phone...