Is it possible to realise pivot in SQL Server query without aggregation?
I have column to be the titles of the columns and column to be the values in these columns in rows with similar foreign key - how to realise this?
I've read answers about no aggregation in pivot in SQL - is it so?
I need to use MIN (while I have the only one value in the row, transferred to column).
(I haven't used all the possible column names from column22 in query)
Is it ok?
