Outstanding! Looks like I have some homework now.

Thank you so much. You've been a tremendous help.

Jeff

Thank you. I can understand the logic behind it and I'll see how to make it work within Query Analyzer.

Here's how I'm going to apply this. I have created a...

I changed the clustered index to logDate. I took the LEN(DestHost) part out of the query and re-ran it. It came back in 1:20. Better, but not good. Then, as...

As far as the columns I have, they were created by ISA Server and that's the way ISA needs to have the table constructed to be able to INSERT to...