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

1

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

SELECT
  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

Options:
Switch sites:
loading Hold tight while we fetch your results