stored procedure - using various conditions [Resolved]

Posted by Pallubhosale under Sql Server on 2/27/2015 | Points: 10 | Views : 1191 | Status : [Member] | Replies : 0
hi all,
table Student contains 600 student . I want to make 24 groups of student from below criteria:
every group should contain student according to differnet
course_code,
sex,
nationality,
race,
area_special
if possible..
Each group should have 1 female if possible,
The aim is to have maximum diversity

Student table coloumns are ... MetricNo,courseCode,studName,sex,nationality,race,area_special etc..

Pallavi


Responses

(No response found.)

Login to post response