SQL Server 表行列转置

DECLARE @sql VARCHAR(8000)
SET @sql = 'select  UserCode,UserName, HumanID'
SELECT   ',Sum(case PSid when ''' + PSid + ''' then amt else 0 end) [' + PSid + ']'
FROM    (SELECT DISTINCT
                PSid
         FROM   ls_amt) a  
SET @sql = @sql + ' from ls_amt where humanid is not null group by usercode,username,humanid '  
EXEC (@sql)

--ls_amt表共计5个字段 UserCode,UserName, HumanID,PSid ,amt