Viewing 15 posts - 991 through 1,005 (of 3,543 total)
Which temp table?
#temp3 will contain one row for each row in #temp1
#temp4 will contain one row
#temp5 will contain one row for each row in #temp1 plus whatever fPerformanceHistoryDetail retrieves
So if...
April 24, 2012 at 1:56 am
Lynn Pettis (4/20/2012)
Because once in while you think you see a light starting to go on. But then it flickers out again just as fast.
Or maybe it was too...
April 20, 2012 at 10:25 am
INSERT #temp3 (account,MTD,ytd)
SELECT t1.account,
COALESCE(t1.MTD,t1.m1 + a.i1),
COALESCE(t1.ytd,t1.y1 + a.i1)
FROM #temp1 t1
LEFT JOIN #temp2 t2 ON t2.account = t1.account
CROSS APPLY...
April 20, 2012 at 10:20 am
INSERT #temp3 (account,MTD,ytd)
SELECT t1.account,
COALESCE(t1.MTD,t1.m1 + account(@p1)),
COALESCE(t1.ytd,t1.y1 + account(@p1))
FROM #temp1 t1
LEFT JOIN #temp2 t2 ON t2.account = t1.account
April 20, 2012 at 7:36 am
Do you have any messages in Sent Items/ Deleted Items ?
April 12, 2012 at 10:24 am
Sent myself a PM and it worked OK 🙂
April 12, 2012 at 10:18 am
SQLRNNR (3/27/2012)
When did we start doing milestones for the 5k posts? I thought it was 10k.
A milestone is a milestone is a milestone, don't be so damn picky 😛
I...
March 28, 2012 at 1:53 am
Brandie Tarvin (3/27/2012)
David Burrows (3/27/2012)
Sorry Brandie for stealing your thunder. Feel a little guilty now :blush:
You should!
jcrawf02 (3/27/2012)
March 28, 2012 at 1:48 am
Lynn Pettis (3/27/2012)
David Burrows (3/27/2012)
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
And No 😀
And the gentleman from the UK WINS!
Bit of a cheat really as I was only lurking...
March 27, 2012 at 9:31 am
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
And No 😀
March 27, 2012 at 9:22 am
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
No 😀
March 27, 2012 at 9:22 am
Replace 'am' and 'pm' with alternate unused char, ie char(0) and char(1) and reverting back afterwards may help with the char removal with tally table
March 12, 2012 at 9:57 am
John Hanrahan (3/6/2012)
Glad you all enjoyed the question. I enjoyed the 'whininess' and 'pendaticness' of some of the responses. It's all good.At least I got a point today!
John
Kudos...
March 6, 2012 at 10:12 am
Nils Gustav Stråbø (3/6/2012)
I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:I promise to never try to be one again...
The...
March 6, 2012 at 6:49 am
SQLKnowItAll (2/23/2012)
It doesn't look like that will do any good since the identifiers for the event are on a separate line.
Not sure what you mean by this, since each row...
February 24, 2012 at 1:53 am
Viewing 15 posts - 991 through 1,005 (of 3,543 total)