rambilla4 (8/24/2009)

---

thank you very much,

What is your .trn file, which is generated by Log shipping backup job?

Question, it is what it is, why is it so important to know...

William Plourde (8/24/2009)

---

Thanks for the suggestion but AutoClose is set to False. I did notice the following: Initial datafile size was 152mb, current size is 569 mb, and growth rate...

Done I am, here is the new code. Work this will in SQL Server 2000.

Edit: Special note there is, clustered index mandatory it is. Work it won't...

Matt Miller (8/24/2009)

---

You could use a modified version of Jeff Moden's "running total" solution to carry the value around. In high cardinality sets - it should outpace the correlated...

Check the properties of the database and see if the auto-close option is on. If so, that would explain it. With that option on, the database shuts down...

Read the first article in my signature block below regarding asking for assistance. Follow the instructions in that article and post the DDL for your table(s), sample data, and...

Here is an updated set of code.

DougGifford (8/24/2009)

---

It appears to me that Lynn's code assumes the data is entered in time_stamp order and the ID for the previous Time_Stamp is one less than the current record.

Where...

Okay, that is what it IS doing. I am interested more in what it is SUPPOSED to do. To see that we need sample data for the table,...

Could you post some sample data and expected results? This would help figure out the problem.

Or you could use the attached code (couldn't post it directly, again).

Yes, you are permitted to yell. I'm glad we were able to help you find the problem. Sometimes it just takes another set of eyes. Typical Forest...

Why?

Again, look at the error message. It is not complaining about the temporary table:

Msg 4701, Level 16, State 1, Procedure SP_REFRESH_CHEMPAX_COSTS, Line 30

Cannot find the object "CHEMPAX_COSTS" because it...

Sample Data? Expected Results?