>If I had a report to produce that some of it could be created with a SELECT, but the rest had to be produced by running a program, how would I produce the end result data.
>
>Should I use a Read/Write Cursor?
>
>Thnaks
>Kev
That's what I do for most of my reports. I'll either turn a read only cursor into a R/W one, or I'll use a table that has a none updating view. I use the view to build the cursor, and when I'm done I just close the view - since it doesn't update the table there isn't any cleanup needed.