Thanks Greg. Peter's solution is working for me, but I appreciate the input.

When I tried your method I got an error. I realize I'm using SQL...

Even better. Thanks again.

Works perfectly! Cross Apply is a new one for me.

Does Cross Apply work in SQL Server 2005? I'm getting -Incorrect syntax near the keyword 'VALUES'.

Also, making it slightly more challenging - two more fields, LExecuted, and...

I truly appreciate it. I'll see if I can make that work. If I have to follow up with another question I'll post a table def and insert...