Those times you were stupid and you asked twice on the same day


Please login or register to vote for this query.

(click on this box to dismiss)

... so they don't count for the Asking Days badges curious/inquisitive/socratic.

Stack Overflow

Q&A for professional and enthusiast programmers

  questions.Id AS [Post Link],
  cast(questions.CreationDate As Date) AS 'date',
  initialQs.Id AS [Post Link]
FROM Posts questions
JOIN Posts initialQs 
  ON cast(initialQs.CreationDate As Date)=cast(questions.CreationDate As Date)
WHERE questions.OwnerUserId = ##UserId##
  AND questions.PostTypeId = 1 --questions
  AND initialQs.OwnerUserId = ##UserId## AND initialQs.PostTypeId = 1
GROUP BY questions.CreationDate,
         questions.Id, initialQs.Id, 
         cast(initialQs.CreationDate As Date)
HAVING questions.CreationDate > MIN(initialQs.CreationDate)
ORDER BY questions.CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results