求一sql语句

[netajax1]

create table Student(
	StudentID char(36),
	StudentName varchar(30),
	StudentNo char(11)
)
insert into Student(StudentID,StudentName,StudentNo)values(NEWID(),'张三','001')
insert into Student(StudentID,StudentName,StudentNo)values(NEWID(),'李四','002')
insert into Student(StudentID,StudentName,StudentNo)values(NEWID(),'王五','003')

create table TargetTb(
	TargetID char(36),
	TargetName nvarchar(50)
)
insert into TargetTb(TargetID,TargetName)values(NEWID(),'肥胖')
insert into TargetTb(TargetID,TargetName)values(NEWID(),'瘦小')
insert into TargetTb(TargetID,TargetName)values(NEWID(),'正常')

select * from Student
select * from TargetTb

create table TargetIDRECORD(
	ID char(36),
	StudentID char(36),--Student StudentID
	TargetID char(36)--对应TargetTb表TargetID
)


insert into TargetIDRECORD(ID,StudentID,TargetID)values(NEWID(),'F552D01F-1406-41DE-B073-6B4DA6B9CCD7','07907108-B4E8-45ED-AC54-189725E3B50B')
insert into TargetIDRECORD(ID,StudentID,TargetID)values(NEWID(),'F552D01F-1406-41DE-B073-6B4DA6B9CCD7','3AA2B5DF-6EC3-40F0-807C-9B576F1AC467')
姓名 学号 （所有标签）

姓名  学号  肥胖  瘦小  正常
张三  001     1     1     1
李四  002     0     0     0
王五  003     0     0     0

[junshanhudazhaxi]

你这是一个行列转换问题，参考下面的网址内容，你可以自己搞定的。
http://www.cnblogs.com/zhangzt/archive/2010/07/29/1787825.html