>>temporary tables can be just as problematic as cursors, especially if they're created via SELECT INTO. <

Hmmm .... can't win, no matter what you do ... <g>



>>> FWIW, I don't think we use sql cursors in *any* of our SP's (or triggers) ... we use temporary tables. I guess this must be the reason why!
>
>temporary tables can be just as problematic as cursors, especially if they're created via SELECT INTO.
>
>While, in general, you'd like to stay away from cursors, sometimes it the only want to get down what needs to get done. In that case, your best bet is to use the FAST_FORWARD option on the cursor.
>
>-Mike