Sql-server – why does the pivot give me an error

pivotsql-server-2005

Msg 207, Level 16, State 1, Line 1
Invalid column name 'FullName'.

select FullName, 
['1-Urgent'], ['2-High'], ['3-Medium (3000)']
from (select FullName,AltBusinessSeverity, total from Mdata) AS ST
PIVOT (
min(FullName) FOR  AltBusinessSeverity in (['1-Urgent'], ['2-High'], ['3-Medium (3000)'])
) AS PT

Best Answer

If you want to show total as your data, then you need to do the following:

select FullName, 
['1-Urgent'], ['2-High'], ['3-Medium (3000)']
from (select FullName,AltBusinessSeverity, total from Mdata) AS ST
PIVOT (
min(total) FOR  AltBusinessSeverity in (['1-Urgent'], ['2-High'], ['3-Medium (3000)'])
) AS PT
Related Question