I was wondering if anyone had a way to generate report output like "D/2, 4, 6; E/2, 4, 6" in a single field for seating locations and the like. I would like to be able to report on this data without having a separate row for each seat/SLI.
So far I think this would probably be easiest with an aggregate function and GROUP BY clause, but it appears you can't actually define your own aggregate functions without CLR, and that's getting to be pretty far outside my area of expertise.
Any ideas?
Hi Nick - here's a simple table valued function that I've used to get seat locations in a comma separated list. It probably could be adjusted to add in section or zone or the like if needed. Here's the link to file: