0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

declare @NumberOfStudents int
declare @StudentsPerGroup int

set @StudentsPerGroup = 10
set @NumberOfStudents = 104

select number, ntile((@NumberOfStudents / @StudentsPerGroup)+1) over(order by number) as GroupID
from master..spt_values
where type = 'P' and
      number between 1 and 104

fork query

edited mar 16 12

created mar 16 12 Mikael Eriksson