0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

DECLARE @date1 date = '01-01-18';
DECLARE @date2 date = '12-31-18';
select distinct top 50 DisplayName from users 
  join posts 
  on users.Id = posts.OwnerUserId
  where posts.CreationDate < CAST('2018-01-01' AS DATE) or posts.CreationDate > CAST('2018-12-31' AS DATE)
-- between @date1 and @date2

fork query

edited nov 12 19

created nov 12 19 anonymous