I tend to avoid the SUM() OVER and related functions for another reason.

The Performance of the T-SQL Window Functions[/url]

Except in cases where a query is really complex already and the...

I don't really subscribe (generally) to the notion that breaking a query into separate pieces using temp tables makes it any easier to understand.

To me, properly formatting the query to...

TomThomson (3/8/2015)

---

Jeff Moden (3/1/2015)

---

I'm not so sure...

marcia.j.wilson (3/6/2015)

---

Can't express my agreement strongly enough with the following:

I really hate it when I have to wade through what I’d call “stream of consciousness” or write-only SQL. This...

lshanahan (3/6/2015)

---

Timely repost. I was just creating my first-ever sp involving dynamic SQL this week when I saw this.

My scenario wasn't nearly as complex, but this article (with appropriate...

omarlopez7 (3/6/2015)

---

you can replace this part of the query

"Last_Status_DT >= '2013-10-25'

AND Last_Status_DT < '2013-10-29';"

For this one

"Last_Status_DT between '2013-10-25' and '2013-10-29';"

And...

SQLRNNR (3/6/2015)

---

dwain.c (3/5/2015)

---

SQLRNNR (3/5/2015)

---

I...

SQLRNNR (3/5/2015)

---

I would say...

Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not play well with IE11?

Late to the party, but perhaps this does what you're looking for:

WITH SampleData (s) AS

(

SELECT 'Admin -- Assistants'

UNION ALL SELECT 'Finance --...

I have the distinct impression that my under-caffeinated brain is missing something here, but can't you just skip the first step and do something like this?

SELECT id, account, deposit, rtotal,...

Solomon Rutzky (3/4/2015)

---

dwain.c (3/1/2015)

---

Ah. I couldn't remember specifically what I was doing with respect to rounding. Mine was more a demonstration of the method, and I did not...

Greg Snidow (3/3/2015)

---

Excellent article indeed Dwain. Especially from a...

To me this looks like a combination of a "data smear" and a running totals problem.

Perhaps you'll find some ideas here:

Filling In Missing Values Using the T-SQL Window Frame[/url]

rCTEs are not the only way, and often aren't the fastest way:

The...