Viewing 15 posts - 1,951 through 1,965 (of 5,678 total)
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 18, 2012 at 3:09 pm
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 =...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 18, 2012 at 2:47 pm
Revenant (1/15/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 15, 2012 at 10:09 pm
David.Poole (1/13/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 4:44 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 3:16 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 3:06 pm
GSquared (1/13/2012)
Catastophic disaster to break it up...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 2:50 pm
Brandie Tarvin (1/13/2012)
Evil Kraig F (1/12/2012)
This is more a linked server than a job issue. The proc itself won't error, so the job is clueless there was a problem.
When...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 2:39 pm
Steve Jones - SSC Editor (1/13/2012)
SQL Kiwi (1/13/2012)
What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.
Arguments are welcome, but it...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 11:55 am
L' Eomot Inversé (1/12/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 13, 2012 at 2:18 am
george sibbald (1/12/2012)
Chuck Hottle (1/12/2012)
What's a visit?
thats a good question.
My visit count is more than double my posts, either some people remain logged on for ever or visits are...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 5:05 pm
nick-1043370 (1/12/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 5:03 pm
george sibbald (1/12/2012)
Thanks Craig, always the bearer of good news. 🙂
There's a reason I'm Evil! 😉
I knew I was going to have to do some more work to actually...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 4:55 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 4:05 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 12, 2012 at 3:56 pm
Viewing 15 posts - 1,951 through 1,965 (of 5,678 total)