Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Been there, done that, got the t-shirt. 😉

You probably got a concussion from banging your head on your keyboard too many times. 😛

Actually, Mitch, Matt and I are asking for the same thing. Thank you for your existing code, but we still need the DDL for the table(s), sample data, and...

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.