Q&A for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description /*select top 20 dateadd(CreationDate, datediff(CreationDate, 0, getdate()), 0), count(1) from Users group by dateadd(CreationDate, datediff(CreationDate, 0, getdate()), 0) order by 1;*/ select top 20 dateadd(mm,datediff(dd, 0, getdate()),0),CreationDate from Users;