I ran the execution plan as requested. It advised me to add a new index, which I did, time now 3secs.

Complete New index file attached, as well as execution...

Index Scripts as requested. I am over the moon with 12 secs, now I understand why I was obviously happy once with 39 mins. I like your enthusiasm...

Hi Gianluca Sartori,

I would like to thank you for all your help with this cursor issue. When tested against the same data set your query produced identical results to...

Hi Gianluca Sartori,

Thank you very much for your asistance with this, and so quickly too.

I must thank you for an elegant looking solution. I am looking forward to running...

Silly question. Is there an easy way for me to copy this code as it is formatted? When I copy and paste from the windo it all comes...

Hi,

I struggled a little with + QUOTENAME part of exporting the data, all I seemed to get was NULLS so I have added a rar file. This contains three...

Hi Thank you for your reply.

I have read your post suggestions and am happy to try and create the information as requested. Just to clarify, presumably you require the...