The rb_invoicestoprocess table has no indexes on it.

The idea is that the table will have many rows in it at any given time and I will only process it one...

The 2 table you refer to have only 1 row in them ---

The 80K of invoices is in the rb_invoicestoprocess table --- this is the list of items that I...

Wayne,

I examined the 2 procedures and managed to change 1 of the "UNIONS" to a "UNION ALL" -- the second cannot be changed as there may in fact be duplicates...

Here...

Hi Wayne,

First off -- thank you som uch for your help!

I am just in the process of reloading my test data to get the same volume (100,000 lines) -- I...

Wayne,

I dropped all the old procedures and ran the script you sent....

the numbers all look correct....

I did fix the procedure names -- so just so we are on the same...

Wayne,

Item #1

- I removed the variables you mentioned. Does having these extra variables "hanging around" cause preformance issues?

Item#2

I missed something in the conversion -- and that varibale was not...

All,

Here is the information requested to assist with this problem. I tried to follow your advice in the links at the bottom of your signatures as best I could,...

Thanks Wayne...

I have started to complied all the information -- it will be 9 tables and a small set of data -- including 2 stored procedures....

Unfortunately I accidently deleted all...

Wayne,

I have taken you code and I am having some sucess with it -- can you give me an example of how to eliminate the last cursor? (you make reference...

G Squared --

Thanks for the note -- that was what I was looking for -- not a solution, just something to look into.

I have never used a "cross apply"...

Thanks....

Trying to generate test data -- this might take awhile...

I think you are correct -- although the word 'partition' is confusing me.

Basically I have a list of invoices that I need to calculate total values on -- these calculations...

All,

maybe if I provide some background information as to what I am trying to accomplish you can provide some hints --- if that does not pan out I will post...

You are right -- it needs to be changed to full.

The transactions backups were created with the intention of truncating the log files....

I did not set this up -- I...

Checked the event log -- nothing (no errors)

There was effectively nothing happening with the db during this period -- a small amount of data was added