Viewing 15 posts - 991 through 1,005 (of 3,544 total)
Born a developer.
Live a developer.
Retire a developer.
Die a developer.
Change job?
meh
Far away is close at hand in the images of elsewhere.
Anon.
May 1, 2012 at 7:09 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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
Far away is close at hand in the images of elsewhere.
Anon.
April 20, 2012 at 7:36 am
Do you have any messages in Sent Items/ Deleted Items ?
Far away is close at hand in the images of elsewhere.
Anon.
April 12, 2012 at 10:24 am
Sent myself a PM and it worked OK 🙂
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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)
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
March 27, 2012 at 9:31 am
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
And No 😀
Far away is close at hand in the images of elsewhere.
Anon.
March 27, 2012 at 9:22 am
Brandie Tarvin (3/27/2012)
No milestone for him. ME ME. GIMMIE!POST!!!
😀
No 😀
Far away is close at hand in the images of elsewhere.
Anon.
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
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
March 6, 2012 at 6:49 am
Viewing 15 posts - 991 through 1,005 (of 3,544 total)