Jeff Moden (11/1/2011)

---

Do a single lookup for the "trail off" row and substract it from the SUM.

You're already at the "leading" row during an UPDATE... add it to the SUM.

Calculate...

Heh, I wonder if we're thinking along the same lines Jeff. I'm currently puzzling out a rolling window mechanic that should only need one (maybe two) passes on the...

Jeff Moden (10/31/2011)

---

I was simply going to add the date, EmpID, and 3 calculated columns to the detail table and hide them from the app using a passthrough view with...

Jeff Moden (10/31/2011)

---

Evil Kraig F (10/31/2011)

---

Jeff Moden (10/31/2011)

---

Kiara (10/31/2011)

---

Jeff Moden (10/29/2011)

---

Kiara,

Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that...

L' Eomot Inversé (10/31/2011)

---

I guess I have to disagree with that. For a collection of small databases it has (for a long time now) been a lot more expensive...

gcresse (10/31/2011)

---

Thanks, Craig. When you say "dump it into #tmps" do you mean write the data that I'm trying to get out of my subqueries into temp tables and...

gcresse (10/31/2011)

---

Is it possible to include a subquery on the table being updated in the quirky update? I'm experimenting with the following code but the subqueries are not returning updated...

rka (10/31/2011)

---

How will this work when addresses are like:

Dummy Management Unit PO BOX 999 Dept of Energy, Training and The Arts CITY EAST DummyState 9999,

Unit 1/100 Dummy Street, DummySuburb,...

My pleasure. You're correct though, you do want NOCOUNT off, but that's standard for me (sorry, was pseudocode above). FMTDATA setting is only needed under...

Ten Pounds of Knowledge, One pound bag. Lesson one: Learn the keywords and what it can do, and lookup how to do it after. Eventually the methods will...

Jack Corbett (10/31/2011)

---

Evil Kraig F (10/31/2011)

---

You guys are looking at a race, I'm trying to...

Jeff Moden (10/31/2011)

---

Kiara (10/31/2011)

---

Jeff Moden (10/29/2011)

---

Kiara,

Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give the reporting performance...

You guys are looking at a race, I'm trying to figure out how to grab...

Yeah, it's fine except you have to put in a metadata component first.

SP as a data source runs into trouble when it's multi-statement, particularly if you use INSERT INTO #tmp....

Yeah, it's one ROYAL PITA. You're not just on the hook at 2AM for server...