Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help On Query RE: Help On Query
TheSQLGuru
SSC Guru
Points: 134017
More actions
September 10, 2013 at 11:22 am
#1648981
For those using ROW_NUMBER, if you want users having 2 OR MORE roles, shouldn't the filter be rownum >= 2 instead of just rownum = 2?
Best,Kevin G. BolesSQL Server ConsultantSQL MVP 2007-2012TheSQLGuru on googles mail service