Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Correlated Subquery Optimization
That's it! Thanks a ton, that works perfect. -
Correlated Subquery Optimization
I have been searching for the best way to do what I think should be a simple task in SQL. I have a table full of call history events and I want to get a summary of some events for each calling party that matches the form "username(extension)". Using correlated subqueries I do the following...
