Its freaking horrible. Its due tomorrow and I'm nowhere near done. Just left work (got kicked out by the cleaning crew))) and will be up all night trying to finish from home
You, guys, saved me a bunch of time. There's 7 sets of 5 sets of columns that have to be spread out like this. I had a way of doing it with 4 queries for each set, so 35 times 4
Now its only 14 thanks to that amazingly simple one query way
I will study yours, chris, and the 4 other examples here just to learn once I'm done with this atrocity))))))))
Thank you all so much
I can't praise this forum enough