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()) select ROW_NUMBER()OVER( order by cnt desc,firstname) num,* into #out from #temp order by cnt desc select * from #out where num between (@pagenum-1)*50000+1 and @pagenum*50000 order by cnt desc , firstname