Re: SQL Fun Challenge #2

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:c26ruv$kgd$1_at_titan.btinternet.com...

> Adopted ?
> Step-children ?

Boris asked for children, not kids. So I assumed he meant genetic. But granted: it's a cultural thing: we always assume "children" are the genetic ones, down here.

> > (or else Mum will declare war...):
> If it can go wrong, it will.

:D
Been there done that?

> Good point - Boris and Vladi are both mathematicians,
> but not architects, so they may have different perspectives
> of what to count for a double-fronted bay window.

I actually looked outside the window to see if I could find non-obvious things like number of windows in a building always being even instead of odd. But I stopped when I saw the glass and steel tower in the corner of Mount and Walker: it just could NOT be relevant!
:)

> > Darn you, Daniel! You had to throw a spanner in the works, didn't you?
> > I'll have to assume an exception: twins!
>
> That's not an exception, it's a corollary to a well-known rule
> if you can't afford it, it happens
> (see above)

For extra points: can anyone explain WHY the exception MUST be twins? I'm talking in the SQL context, of course.

> Note that the final solution shows that he was suckered
> into the twins - the first attempt gave him one child and
> a false sense of security.

Like my wife says: in the first 6 months, all kids will lull you into a false sense of security, peace and quiet. Then they become "individuals" and all heck breaks lose...

> When I tested this out ('the youngest has a pet hamster
> with a wooden leg') in one part of America, it fell flat
> because the audience generall didn't consider twins to
> be the same age. Luckily I tested it before going into
> production in front of a full audience.

There is one in every crowd!...

> Part 2:
> Produce a solution from an account that has
> only the "Create session" privilege.

Attempted in another reply. But I'd attempt do it with a single dynamic view rather than three, using the discriminator column I pointed out near the end of my solution.

Ah well: let's hope no one asks us to do this in DB2/AS400...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam