DECLARE @sql VARCHAR(8000)
SET @sql = 'select FParentID,FItemIndex '
SELECT @sql = @sql + ' , max(case FFieldExplain when ''' + FFieldExplain
+ ''' then [FValue] else null end) [' + FFieldExplain + ']'
FROM ( SELECT DISTINCT
FFieldExplain
FROM AVI.DBO.TAOIEx

) AS a
SET @sql = @sql + ' from AVI.DBO.TAOIEx
group by FParentID,FItemIndex'
EXEC( @sql )