Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software
declare @pagenum int = 1; select case when CharIndex( ' ', displayname )=0 then lower(displayname) else Substring( lower(displayname), 1, CharIndex( ' ', displayname ) - 1) end as firstname, id cnt, reputation rep, upvotes upv, downvotes downv into #temp from users where year(LastAccessDate)=year(getdate())