>>>Were you thinking that select into a cursor/table would be faster or slower than this?<<
>
>yep. don't use the clause at all (for a temp cursor)
OK, I'll run some tests and get back to you. Here is my seat-of-the-pants prediction: no significant difference between any of the INTO methods including no INTO at all.
Peter Robinson ** Rodes Design ** Virginia
