Lets say you have a dataset that is returning a bunch of rows but you have a top N or some kind of a filter……
The problem with case statements is that usually each one takes up a row for itself and then assigns a NULL value for the next……
Lets say you have a dataset that is returning a bunch of rows but you have a top N or some kind of a filter……
The problem with case statements is that usually each one takes up a row for itself and then assigns a NULL value for the next……