Do you mean to ask about how much slower this will make your system? Working with cursors is extremely fast, I don't think you will notice any difference.

>thanks again Tore,
>
>The problem for me is that I have a framework and all queries run thru a method so imagine for the large queries, first run the query and then append a large amount of data, 2 hits, so this makes me uneasy. How hard of a hit have you found for queries that return large amount of records?