It's basically for a crystal report.

I've thought about trying to accomplish the same thing through Crystal, but thought I would look SQL first.

I figured it out with a pivot in...