2011-11-03, 02:03 PM
IImaplers Wrote:It can always be created within its own temporary table as a column and thus as an entity. Sometimes when you try to explain things the simplest possible way people divert from trying to understand the explanation and put their own meaning to it. When I mentioned "column" it was implied that it would be the min date from a separate table (also, never did I assume such a date column exists). I think you got the idea from the start though. This argument is pointless.
And nice job showing off how smart you are. Fyi, I also work with SQL as a developer (not to rub it in of course).
"created within its own temporary table as a column" would be done how?
Right! Via join.
The time/space tradeoff you (or your database's built-in optimizer) decide to use is irrelevant.

