3 ms·

SQL Server has a ternary. So your example would be written like: select iif(a < b, 1, 0) as ab, iif(b < c, 1, 0) bc... Unsure what crosstabview is as I've n

• oerpli 7y ago
  This makes it somewhat easier on the eyes but is still 80% too verbose. Crosstabview converts a table from: |a x 0 |a y 1 |a z 2 |b x 1 |b z 5 to | x y z |a 0 1 2 |b 1 5