Display some table

[thanhcong_12a4]

Hi all,

I have SQL db :
- Teacher: Teacher_id nvarchar
Teacher_name nvarchar

- Class : Class_id nvarchar
Class_Name nvarchar

- Week Week_id int
Week_name nvarchar

- Subject: Subj_id nvarchar
Subj_name nvarchar

- Schedule_of_tcher: Teacher_id nvarchar
Class_id nvarchar
Room nvarchar
Start_week int
End_week int
Subj_id nvarchar
Time nvarchar (it means that morning or Noon)

How I can display table like below?
(the table depend on the Teacher_id )


Week 1
Mon Tue Wed Thu Fri Sa
Morning Math1 Math2 Geo
Class 1 Class3 Class1
Room1001 room 1002 Room 101

Noon Math2 Geo
Class3 Class1
Room 1002 Room 101

And when we select from Week 1 to Week 5 we’ll have 5 tables like:

Week 1
Mon Tue Wed Thu Fri Sa
Morning Math1 Math2 Geo
Class 1 Class3 Class1
Room1001 room 1002 Room 101

Noon Math2 Geo
Class3 Class1
Room 1002 Room 101

Week 2
Mon Tue Wed Thu Fri Sa
Morning Math1 Math2 Geo
Class 1 Class3 Class1
Room1001 room 1002 Room 101

Noon Math2 Geo
Class3 Class1
Room 1002 Room 101
...........
Week 5
Mon Tue Wed Thu Fri Sa
Morning Math1 Math2 Geo
Class 1 Class3 Class1
Room1001 room 1002 Room 101

Noon Math2 Geo
Class3 Class1
Room 1002 Room 101

but in Week 4 the teacher begin teach Math3 on Wed(Noon) and he finish Math1 on Tue
+ and we have:
Week 4
Mon Tue Wed Thu Fri Sa
Morning Math2 Geo
Class3 Class1
room 1002 Room 101

Noon Math2 Math1 Geo
Class3 Class 1 Class1
Room 1002 Room1001 Room 101

+in week 5 he busy on Fri :

Week 5
Mon Tue Wed Thu Fri Sa
Morning Math2
Class3 Busy
room 1002

Noon Math2 Math1 Geo
Class3 Class 1 Class1
Room 1002 Room1001 Room 101


Help me please !
Thanks all:)