We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Sorry if this is no longer helpful to yourself, but others may want to know.
When using PIVOT you need to use an aggregate function.
Because there is only one name associated with that specific row MAX(NAME) can be used. MIN(NAME) can also be used.
If you wish to read more take a look at this article
Occupations
You are viewing a single comment's thread. Return to all comments →
Sorry if this is no longer helpful to yourself, but others may want to know.
When using PIVOT you need to use an aggregate function. Because there is only one name associated with that specific row MAX(NAME) can be used. MIN(NAME) can also be used.
If you wish to read more take a look at this article
http://sqlmag.com/t-sql/pivoting-without-aggregation