ChrisM@Work (10/2/2012)
If you can't code it up as a view, then it's unlikely that you can code it up as a query.
You could still do it as a quite complex function, but I guess that would be wasteful.
Also, I am not stuck on functions vs views; if there are any other ideas/tips that I could use to keep the business logic more manageable, please mention them...