Roughly sure this is what you need:

SELECT

sv.Broker_NB,

sv.Contract_NB,

ahd.WEATHER_STATION,

sv.FIN_YEAR,

sv.FIN_MONTH,

ahd.[Date],

sv.ACCT_NO,

sv.BILL_YEAR,

sv.FROM_DATE,

sv.TO_DATE,

ahd.HDD,

ca.HDDSUM AS TOTHDD

FROM

[NADECORP\SNjenga].StagingVolume AS sv

JOIN

[NADECORP\SNjenga].ACTUAL_HDD_DAILY AS ahd

ONsv.Weather_station = ahd.Weather_station

CROSS APPLY

(SELECT SUM(HDD) AS HDDSUM

FROM

ACTUAL_HDD_DAILY AS ahd2

JOIN

StagingVolume AS sv2

ONsv.BILLDATE_ID = sv2.BILLDATE_ID

JOIN

EXISTING_CUST_ALPHA_BETA AS ecab

ONahd2.Weather_station = ecab.weather_station

AND ecab.account_number...

Ow, my head hurts wrapping around this logic. I'll have to come back to it, but for anyone looking for an easier read, here's the query formatted:

SET @intRowNo =...

Revenant (1/15/2012)

---

The problem, or at least one of the problems, is that the tests are ALWAYS behind the state of the art. We may talk about brain dumps and all...

David.Poole (1/13/2012)

---

I think FU$ money probably wouldn't bring happiness to the under 40s. (Spot the bias). I think you need to reach a point in your life where you...

I gotta go with HOW much FU money?

If it was a little bit, like a year or three off, well, meh. Keep working and take a 3 week sabbatical...

I need a favor. I'm trying to use Microsoft Connect and I'm... well... really the only time I go there is when someone links a particular issue. I'm...

GSquared (1/13/2012)

---

That's my preference, pretty much spelled out. (I wrote much the same, but with somewhat less detail in the original thread we're discussing.)

Catastophic disaster to break it up...

Brandie Tarvin (1/13/2012)

---

When...

Steve Jones - SSC Editor (1/13/2012)

---

Arguments are welcome, but it...

L' Eomot Inversé (1/12/2012)

---

Compared to that guy you are perfect model of tact and good manners and politeness - there's just no time I have ever seen a post from...

george sibbald (1/12/2012)

---

thats a good question.

My visit count is more than double my posts, either some people remain logged on for ever or visits are...

nick-1043370 (1/12/2012)

---

Speaking for myself I'd rather get something, work out whether it works in the context of the problem, and then re-pose the question if necessary. If someone else suggests...

There's a reason I'm Evil! 😉

I knew I was going to have to do some more work to actually...

Confirmed. 2k8 R1 SP3 does NOT fail the query on query timeout through to a SQL 2k5 server. I do not currently have two 2k8 instances to play...

Nice Lowell, gratz.

And yes, you almost always contribute on every post you make, I don't think anyone believes you'd 'pump' the count. 🙂 The Thread doesn't count. 😉

;WITH post...