SQLTeam.com | Weblogs | Forums

Using StoredProcedure to solve logical issues

Please help how can i create a stored procedure to automatically distribute subjects to teachers in diferent classes the classes are S1K,S2B ETC based on days without any duplication. in the table please help

|Software Engineering||
|Computer Networks||
|Applied Mechanics||
|List of teachers|No|
|MUKASA JOHN|2-0001|
|MUKISA PAUL|2-0002|