> Any chance you can host a txt file of the query? Without seeing it, > it's hard to say how to optimize it. done: http://www.spinhead.com/callquery.txt thanks, brian, jay, matt, et al I'm fine with less complex SQL, and I've done call reporting before, but this building a view on the fly (I think) and the complexity of the calcs is tough to grok at first pass. I'll also post a sample of the output; it'll be here, but not right away: http://www.spinhead.com/callreport.txt thanks joel