Wow. Cubes and rollup sound nifty. I'll have to google up a bit, as I was like "what?". Sad, I know.
But all that aside, I think you should think about restructuring your data. Specifically your task logic. You can't do something different? Are you in charge of the DB or is someone forcing this format on you? And all the niftyness of a database being what it is, there are still times where it simply makes more sense to not go the "super complicated all-in-one" query route. Sure you may stick with the same DB forever (I wouldn't count on it tho), but what about 6 months from now, when you look at that query and your head spins. Or the table layout happens to change, etc. etc.. I suck at giving advice. Sorry. But I'd look again at the task "linking" stuff, db wise, or perhaps breaking the query up a bit, making it a little easier on the head. There are plenty of ways to cache stuff and whatnot, so what I said about letting the DB do what it was designed for (don't make CF do it all!) is, like much of what I say, partially true. Sometimes it's easier to let CF do what the DB is great at, just for maintainability's sake. Sometimes. Eh, the right tool for the job and all that. I'd think about getting away from the 1.1.1 type stuff tho and use indexes and keys and link tables and whatnot, as that stuff gets gnarly when it gets big. Note: I went the route of recursive linking and for most stuff it's fine, but for other stuff, mostly large stuff (hmmm... ) it kind of sucks. But 6 of one and half a dozen (bakers, or normal ;) or whatever. You could negate X with Y, etc., etc., so... *shrug* If you can't bend the spoon... watch The Matrix. :d On 4/20/06, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions < [EMAIL PROTECTED]> wrote: > > We are using MS SQL 2000. > I do some of the math in the db. > I am very weak with rollup, so maybe you can see what I am missing. > Example: > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
