Mike,

you're going to want to build and execute your sql statement dynamically.

Basically, you're going to build your SELECT statement as a text string. You will execute the SELECT statement...

ghughes,

I tested Greg's statement and it should work fine. The only suggestion that i might make is to provide an alias for the correlated subquery table. But i...

So are the two methods that are mentioned better than using a CURSOR in any way?

Speed?

Memory Usage?

Especially dealing in a high volume (10 of millions) of records.