Answer the question
In order to leave comments, you need to log in
Dropbox: how to unsync for a subfolder?
How to cancel synchronization for a subfolder (i.e. do not make a copy of it in the cloud, leave it only locally) if synchronization for the parent directory is enabled?
Answer the question
In order to leave comments, you need to log in
If the number of events is unknown (or there are many of them for manual entry), then we form a string for the columns through XML PATH. Then, through PIVOT, we convert the rows into columns.
You can also look \ read in the direction of a dynamic pivot table.
If there are only 5 events, for example, then it is possible through
SELECT
ID,
NAME,
MER_1 = COUNT( CASE WHEN mer='MER_1' THEN 1 END),
....
GROUP BY ID, NAME
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question