T-SQL: Aggregate Columns (CASE or Normalization + Aggregation)
In this example I will compare the execution of two possible options to aggregate multiple columns. I have data columns A, B and C and I need to show the average. “CASE” is using a formula ((A + B + C) / (1, 2 or 3)), simulating the scenarios when […]