Darren New wrote:

> Nowadays, I get stuff that's too complicated to do that. Several 
> instances of looping over a result set and building a "Select from X 
> where X.blah in (....)" where the .... is built programatically based on 
> another SQL call.  Or places I'm pretty sure I could figure out but 
> don't have the half a day to spend.  Or stuff I'm pretty sure SQL can 
> do, but I can't figure out how to (mostly with GROUP-BY selection type 
> stuff).

Given time, you could probably integrate the entire thing into one giant 
SQL statement. You'd probably find that you can actually simplify it 
down to something rather smaller once it stated all in one operation. 
And that the DB engine can do some pretty impressive optimisations after 
that too.

OTOH, if you haven't got enough time to do it... what can you do?

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message