Also, if I remember the discussions around Jeff's article on running totals, the only place he has run into difficulties with the technique is with partitioned tables. That is...

Okay, can't wait to see Jeff's response. I was using a technique I picked up from him for completing running totals.

Regarding storing running totals, maybe it isn't stored in...

Hugo Kornelis (11/27/2008)

---

Hi Lynn,

But you are using the IDENTITY...

diehc (11/27/2008)

---

Hello!

I have that compare 2 tables (table1 and table2), if tne rows of the table1 dont exist in table2, have to inserted then in table2 , but if there...

Heh... I may be old, but I'm...

jacroberts (11/27/2008)

---

Lynn Pettis (11/27/2008)

---

jacroberts (11/27/2008)

---

timothyawiseman (11/27/2008)

---

jacroberts (11/25/2008)

---

timothyawiseman (11/24/2008)[hr

This is true, for a small number of rows. Your RBAR TVF will become ineffecient should requirements change and the number of...

Paresh Prajapati (11/27/2008)

---

can we restore as full backup(#1) + tran log backup (#7 through #24) + tran log backup(#26 and # 27 and #28 (with...

Julio Conejo (11/26/2008)

---

With this example in mind, the full started at 12am, and finished at 5 am, but the chief tells us that at 3:01 am one stupid employee did...

jacroberts (11/27/2008)

---

timothyawiseman (11/27/2008)

---

jacroberts (11/25/2008)

---

timothyawiseman (11/24/2008)[hr

>>The problem is that your example did not show a case where efficiency is not a concern.

>>But, in your example you say there is no need...

I'll address a couple of concerns from my point of view.

1. Based on the article, the first 4 values should be zero. This is why I put an isnull...

Good article, but let's take another approach and see what we see.

Taking your sample data from your article, and using a slightly different tact, here is another way to tackle...

No. I said to ignore that backup. Scenerio:

Day 1 ...

Actually, I think that is what we are all waiting for.

I am unaware of any articles that I could point you toward. Your best bet would be to look at some of the books on database design or data...

Could it be he is trying to drop multiple databases? Only the OP knows for sure.