Sorry, was on leave. Thanks for the info.

Thanks for the response. Your point has been noted.

Sorry about that. Attached are the files in a different format.

Thanks for all the suggestions. I will have a look at what you highlighted and give feedback.

The Universe program was modified to read data into a temp file in Universe from sql and to close the connection to sql. Data gets processed in Universe and a...

Hi,

Thanks for all the responses. I ran the query below first:

---------------------

sp_who2 --Run first to see what / who is blocking. Then put SPID below where 133 is.

DECLARE @Handle BINARY(20)

SELECT...

Sorry for getting back to you later than expected. There were a lot of work issues that i had to get round. I have tried to come up with the...

Hi,

Thanks for the help. I now know what to do in future. I have attached the missing tables and some sample data. I took a 100 accounts for the sampling....

Thanks for all your responses. Its code that i inherited and did not write myself and i was not too happy with its speed and fuctionality. I was just looking...

Thanks. Will try that and advise.

Thanks for the response. I understand if you are busy. You can look at it when you have time. I have attached the execution plans for the query. I did...

Hi David,

Hope u r well. Did you manage to have a look at the MatterNumberGetValid stored procedure?

Thanks

Tendayi

I forgot to give you the debtordetail structures. Please find attached.

Hi,

Attached is the sample data and the functions that are used by the MatterNumberGetValid proc. I tried moving the idnumber field up the order in the [_dta_index_ContactNumber_7_948198428__K2_K9_K10_K1_6] index making it...

Thanks for the response. Sorry i did not send the functions and sample data. I will send you the sample data and the functions. I will also make the change...