Random or sequential allocation
-
hello everybody, i have two tables Student and Supervisor StudentId StudentName 1 john 2 paul 3 britney 4 Mike . . . . 13 beckham SupervisorId SupervisorName 1 Martin 2 Tony 3 Janet 4 Brad 5 johnson 6 David 7 Raj how can i allocate 7 supervisor to 13 students equally. any help would be appricaited. regards learner
-
hello everybody, i have two tables Student and Supervisor StudentId StudentName 1 john 2 paul 3 britney 4 Mike . . . . 13 beckham SupervisorId SupervisorName 1 Martin 2 Tony 3 Janet 4 Brad 5 johnson 6 David 7 Raj how can i allocate 7 supervisor to 13 students equally. any help would be appricaited. regards learner
I guess your table
Studentshould contain column which have any value fromSupervisor. Your Student table have to looks like this :StudentId StudentName SupervisorId 1 john 1 2 paul 1 3 britney 3 4 Mike 5 . . . . 13 beckham 7
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.