-- table 是实际表 view是虚表。你可以认为view是一个查询的结果
-- 声明@tbBonds table
declare @tbBonds table(TrustBondId int not null,shortName nvarchar(500),ClassName nvarchar(20),CouponBasis decimal(8,2))
-- 这里涉及到pivot行转列的知识,可参考上一篇文章
select * from (
select TrustBondId,ItemCode,ItemValue
from DealStructure.TrustManagement.TrustBond
where TrustId=@TrustID
)p
pivot
(max(ItemValue) for ItemCode in (ShortName,ClassName,CouponBasis)) t
-- table 表可以和其它表关联
join @tbBonds b on bps.TrustBondId=b.TrustBondId where