@pam Abdulla

Let me explain why with DOS technic and without flow control it may not work.

@john-2 Rowan

Basicly its about collecting data to habe a course description...

Ok, here is the code, some lines I took out (...) only settings.

So the cursor pdfdata can't update the data after the cursor descr has finished. If I start the...

No, there is no nesting.

The code is very long but looks like:

cursor

insert in table x

cursor end

cursor

update in table x

cursor end

It looks like the first cursor would not give...

@jo-2 Pattyn, Couldn't use index tuning wizard because selection of tables are empty.

@Philip Yale, Only with a small set of data it increases, my query is slow as...

The selected data are 30%.

There is a non clustered index on stat_date.

Have not tried the wizard. Sould I delete the indexes first bevore running the tuning wizard?