|
Hello,
I have a table with 2 fields: unique ID, user ID (foreign key) and date-time. This is an access-log to a service. I work in SQL Server but I would appreciate agnostic answers.
I would like using SQL to find for a certain user the ID from where ...
Started by Rax Olgud on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Join....
If desired, you can fix #2 above by changing "t1.time < t2.time" to "t1.time <= t2.time", which will give you a gap of 0 if there is only one record for the user.
Records on the starting or ending boundary of their largest gap.
|
|
Last Saturday at Montrose, Steven Baillie made his second appearance for Queen's Park.
His first was against Stirling Albion on 14th May 2009, a gap of two years and eleven months.
Is anyone aware of a longer gap between a player's debut and his second...
Started by qpsnapper on
, 10 posts
by 7 people.
Answer Snippets (Read the full thread at scottishleague):
For Hibs 1959-1963 It's the Hope I can't stand Longest gap between appearances for Hearts players.
|
|
I wonder if anyone knows the (optimal?) algorithm for longest recurring non-overlapping sub string.
For example, in the string
ABADZEDGBADEZ
the longest recurring would be "BAD". Incidentally if there is no such result, the algorithm should alert that...
Started by Brandon Pelfrey on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I+1]: return index lst.append(i-k+1) else: substrings[cur]=[i-k+1] return -1 def longest_substring.
|
Ask your Facebook Friends
|
Which of the 5 generations do you think is the longest?
I think that DPP is the longest and BW is the shortest.
Started by AvatarMew on
, 24 posts
by 20 people.
Answer Snippets (Read the full thread at pokecommunity):
|
|
Given a list of assorted length words, what is the best way to find the maximum length of any words?
For example, the following should return 6
findMaxLen("a,set,of,random,words")
Of course, it's fairly trivial to do this...
<cffunction name="findMaxLen...
Started by Peter Boughton on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at stackoverflow):
FindLongestWord(char* str) { char* lastComma = str - 1; int longest = 0; int length; char* pCheckChar - 1; if(length > longest) { longest = length; } lastComma = pCheckChar; } } // Check to see if the last word is the longest....
|
|
On Fri, 29 May 2009 08:54:52 -0400, Chris/Power Salad <chaff@powersalad.com
I just noticed that my Janis Joplin parody "Hot Dogs and Beans" was
played in April 1985, then again at the end of 2008. I wonder what the
longest gap between plays on the...
Started by Chris/Power Salad on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
He'd certainly played the flip side of it since then--"Delicious .
So that's
nearly a 35-year gap.
|
|
I came up with this one it runs 29,361 km, 59 days 21 hours
Bear Cove Point Rd to Pineapple Rocks Trk
As far as longest time, I haven't tried as hard at it, but this route is 59 days 23 hours, (but only 29,252 km)
Nain, Canada to Pineapple Rocks
I'm really...
Started by OmnipotentEntity on
, 36 posts
by 22 people.
Answer Snippets (Read the full thread at xkcd):
Darien Gap .
And Equador.
|
|
Not sure if this has ever been asked before, I searched it but couldn't find it ... but I'm curious as to, what is the longest journey one can take in Australia solely by public route bus services?
My guess is Noosa QLD to Macksville NSW, using the following...
Started by triplethree on
, 25 posts
by 19 people.
Answer Snippets (Read the full thread at busaustralia):
But I'm curious as to,....
Longest route buses: Not sure, but I think find it ...
Such as toilets and movies; seat belts are provided; etc.)
If we're going to talk about the longest possible it's really now marketed as a tourist type train.
|
|
Longest ride on a Crotch Rocket.
I've been riding for 12 years, I just got a Crotch rocket and asked around if anyone ever rode one cross country?? How far have you riden?
I found several people saying I was crazy.:willy:
But I just rode from Colorado...
Started by 14063 on
, 20 posts
by 17 people.
Answer Snippets (Read the full thread at twowheelforum):
The longest break I took was like 10 even after replacing the rearsets....
Started at 4:30 am, got home around 7:00 pm.
|
|
I am excited to finally go to Africa for the first time in November. I'm going with Andy Biggs' group to Botswana and also planning a solo extension to Sabi Sands near Kruger. I've talked to Andy already about equipment and gotten some useful input from...
Started by brianz on
, 16 posts
by 13 people.
Answer Snippets (Read the full thread at naturescapes):
You lose a few images with the gap, but you gain a lot more....
To close the gap, I keep the 1.4 III on a 70-200IS II.
Would be better for the gap than constantly adding and removing the converter to the 70-200 and never looked back.
|
