1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

---Posts from MathOverflow an Mathematics with the same title and posted at the same time
SELECT b.Title, a.CreationDate AS "MO Date",  b.CreationDate AS "MSE Date",
       ('http://mathoverflow.net/questions/' + CAST(a.Id AS varchar)), 
       ('http://math.stackexchange.com/questions/' + CAST(b.Id AS varchar))
FROM 
  [StackExchange.Mathoverflow]..[Posts] AS a 
    JOIN [StackExchange.Math]..[Posts] AS b ON a.Title = b.Title
WHERE b.PostTypeId = 1
  and ABS(DATEDIFF(hh,a.CreationDate,b.CreationDate)) <= 12 
  and a.ClosedDate IS NULL
  and b.ClosedDate IS NULL
ORDER BY a.CreationDate;

fork query

edited mar 15 14 anonymous

created mar 14 14 jon.doe7173