Viewing 15 posts - 466 through 480 (of 4,080 total)
You're welcome, Quentin.
I apologize for not posting a link to delimitedsplit8k. It is a tool which should be in everyone's toolkit. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 5, 2016 at 8:56 am
Just did some quick reading. Didn't find a LAG solution, but windowed functions are awesome for this.
In the OPs problem at hand, we need something other than ID...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 4:04 pm
Hey Jeff. I've never done that, but then I don't usually have to do running totals in SQL. Going to go read up on that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 3:52 pm
WARNING WARNING WARNING: You MUST get your inputs standardized. You are at risk until then.
That said. This was a fun problem, and the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 3:45 pm
Fine with me. Here is some reading for anyone else who wanders along.
Solving the Running Total and Ordinal Rank Problems (Rewritten) by Jeff Moden
(I'm oddly unable to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 3:09 pm
What column(s) are you using for your Full Outer Join?
Given the sample data below, it seems obvious that the join should be on the [Eno] column.
A join on...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 2:41 pm
Hey JL: You have two groups of IDs. What result are you expecting?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 2:31 pm
This is a variation on the running totals problem.
The logic is that 100 is subtracted from the first value, 50 is subtracted from the second value, and 25 from the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 1, 2016 at 2:07 pm
Withdrawn for unforgivably not seeing Luis' answer and writing the same thing myself. :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2016 at 3:06 pm
TomThomson (6/24/2016)
Ed Wagner (6/22/2016)
jasona.work (6/22/2016)
TomThomson (6/22/2016)
jasona.work (6/22/2016)
Sounds like the next couple weeks / months are...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2016 at 1:46 pm
I would also like to apply for citizenship to the island.
Be sure it has coconut palms. I think the Professor on Gilligan's Island had...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2016 at 10:44 am
I'm not sure I can beat that one for redundundundancy, but I'm reading through a client app written in COBOL that apparently does a call to the database to get...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2016 at 10:39 am
Without using specific examples to test, it is hard to explain why set-based processing outperforms cursor-based code. Logging certainly plays a part as does the frequency of posting...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 16, 2015 at 12:20 pm
You've got it right that partition switching doesn't physically move the partitioned data. It simply changes pointers that define which table the partitioned data is owned by. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 31, 2015 at 12:32 pm
Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.
That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 31, 2015 at 12:10 pm
Viewing 15 posts - 466 through 480 (of 4,080 total)