I want to do something like the ability to change the style of even/odd rows, but only by columns; I want to have records with a certain field that is even show up on the left, and records with that field odd to show up on the right.
I tried the old pivot technique of putting "IF(Rib % 2 = 0, Rib, NULL) AS LRib" and "IF(Rib % 2 = 1, Rib, NULL) AS RRib", but it ends up doing two rows with one column blank in each. I then did GROUP BY Rib, but that didn't change anything.
Any helpful clues about good ways to this?
Thanks!