怎么用视图把数据由正常的已行显示改为已列显示?(在线等待)
如正常结果显示:
select Name,Value,Date from Table1
Name Value Date
----------------------
name1 value1 date1
name2 value1 date1
name1 value1 date2
name2 value1 date2
name3 value1 date2
name2 value1 date3
name4 value1 date3
改为:
Date name1 name2 name3 name4
-----------------------------------------
date1 value1 value2
date2 value1 value2 value3
date3 value2 value4