« first day (713 days earlier)      last day (3601 days later) » 

22:01
TTGH
I got my query working.
At least I think I did.
9179 rows returned in 122 ms.
SELECT CURRENT_TIMESTAMP AS [WEEKEND!!!];
2
@Hosch250 Gotta head out for a few hours, I'd love to see it when you're done though.
I posted the Q again.
0
Q: Find first questions with answers posted within 24 hours

Hosch250So, sᴉɔuɐɹɥԀ suggested I write a SEDE query to find first questions with answers posted within 24 hours, and here it is: WITH QData(OwnerId, CDate) AS ( SELECT Q.OwnerUserId [OwnerId] ,MIN(Q.CreationDate) [CDate] FROM Posts Q WHERE Q.PostTypeId = 1 AND Q.OwnerUserId IS NOT NULL GROUP...

Mine reports all answers within the 24-hour period, so I get more results
Cool.
22:05
(I didn't specify which way to do it originally, so either is fine)
Apparently @nhgrif's first question was a question/answer combo posted at the same time.
Did you know there are only a couple thousand who have had to wait for over 24 hours, and you are one?
That made it easier to test.
6
Q: How can I condense several IBAction methods in a class with a delegate?

nhgrifI have the following class: MyProtocolClass.h #import <Foundation/Foundation.h> @protocol MyExampleProtocol <NSObject> @required - (void)someRequiredMethod:(NSInteger)someValue; @end @interface MyProtocolClass : UIView // interface stuff @end MyProtocolClass.m #import "MyProtocolClass.h...

@Hosch250 ^^ Yep
Yup.
See you.
22:17
0
Q: Can this heap sort be further optimized to have fewer comparisons?

Joseph Nieldspublic static <T> void heapSort( T[] array, Comparator<? super T> comparator) { int length = array.length; int start = (length - 1) /2; //right-most parent node //build heap while (start > -1) maxHeapify(array, start--, length, comparator); //move m...

22:31
Just 12 more comment flags until Deputy.
rofl, did you guys already see this question in the past: stackoverflow.com/questions/4456438/…
@DJanssens Just yesterday.
It is as good as Little Bobby DropTable.
Or whatever his name is.
@Lyle'sMug That's sort of the opposite of what I was hoping for.
> I want the details area to occupy the base of the screen underneath the graph, and to grow/shrink as the chart grows/shrinks. The last column in the table, the data points, are the largest part of the data, and would 'flood' the area. I want to make it possible to select all the data, but not necessarily make it all visible, a scrolling system would be fine.
Your version does not scale to the size of the area.
22:42
Just 3 more!
2 more, 3 flagged.
GOT IT!
Was that you handling all those flags, @rolfl?
I handled some.... maybe... If you flagged the same question multiple times I was cleaning out the rest anyway
OK.
I just did almost 20 flags in the past 30 minutes or so.
Yes, I handled the last flags in the past 3 minutes.
Jamal mostly handled the rest... as far as I can tell.
I see a busy santa.,..... reversal on its way ;-) (hope not).
Thanks santa.
22:50
Nope, out of votes.
Quick get someone to get you 4 more.
Someone is hammering away at me....
You'll rep cap.
That was me, but I ran out.
I just got my badge, and was trying to help you get yours.
You're supposed to be voting for good answers.... oh, wait, you are ;-0
22:52
what's the amount for the rep cap?
@Hosch250 By the power vested in me, as a constable, I pronounce you Deputy Hosch250
@DJanssens 200
30 to go :p
20.
10.
22:56
BLAST OFF!!!
You folk are ridiculous... but I appreciate it ;-)
lol @rolfl your impact..
Not ridiculous, riDONculous.
Its over 9000
~1.0m
22:57
like I said, over 9000 :D
Between 9k and 2m?
Or 9k and 1.1m?
rounding errors these days.
Mine is ~45k
5k impact here it seems
Of all the stats on my page, this hidden one is the one I like the most:
> visited 534 days, 534 consecutive
3
22:59
I need to edit a few tag wikis.
Not now, though.
See you later.
bye @Hosch250.
wow, even on vacation trips @rolfl ?
Never, ever missed a day.
@Hosch250 I suppose comment-flagging does take effort. ;-)
even on vacation, though, I was somewhat "cheating".... If I visited the site at 23:55 for 10 minutes, I could then basically skip 2 days.
23:15
@Jamal Yep, rolfl posted a query to find comments that can be flagged, and I had to read through them and find ones that were removable.
0
Q: MVC N-Tier Architecture - do I need my UsersDAL Class

Dawood AwanOkay so I am working on a New MVC Web Application, so the Project is in early stages, I have created 4 projects So let me Explain what they do: Common --> Contains all my DTOs, Enums Helpers, ViewModels etc. Web --> Simple MVC Application Business --> This Contains Providers Which have Inter...

Lucky. I may never earn Marshal, but I'm okay with that.
Want the query?
Oh, I suppose you are a mod and don't need to flag.
Maybe you can't flag?
@CaptainObvious That second tag isn't even on SO...
@Hosch250 I can flag, but diamonds cannot earn flagging badges.
Oh.
Why?
23:21
We could easy game the system by making bogus flags and clearing them.
Oh.
I thought moderators were trusted more than that.
But, I did see that mod in the rage quit once.

« first day (713 days earlier)      last day (3601 days later) »