Hi,

Media Gallery is not allowing to upload the solutions..

There is some issue in it.....

Thanks Jacob,

I will use google chrome only in my home..... Anyway, I uploaded from my office, where i have only IE..

For some reason I'm unable to use 'reply' on the forum... The error thrown seems to indicate a security problem :

---

Access Denied: Reply Permission Denied

Either the forum does not exist or you do not have permissions to reply to posts within the forum.

---

I have a question though : why do you guys "insist" to have the input data in Table variables ? They kind of behave different (read : worse) than ordinary tables which is where data normally resides (eg. statistics, indexes, ...) And they make testing slow as for each test one has to declare + load the table again (from an existing table).

=> Wouldn't it be a lot easier to have an empty database with just those tables in it ? The added benefit of (potentially) having indexes on said input data might make the challenge a bit more realistic. Besides, let's agree : @emp and @order don't even have proper PK's !?!? What kind of an example is that in an advanced SQL Challenge ? =/

ps: as for the 'only one query allowed, no variables etc' - rules, I'm no fan of that either as (often) means working around limitations instead of using the full potential of the system. Then again, nobody is forcing me to take part in this =)

Hello,

What if a person has no orders. Should they appear in the results?

Found the answer in the forum

This is so much easier if the organizational chart hierarchy is modeled with a Nested Sets Model and not an Adjacency List Model.

Should the solution works with million(s) of lines?