Actually, this makes perfect sense to me. The CreationTime is a property of the $directory object. In the quoted string, $directory.CreationTime cannot be determined because the parser doesn't recognize it...

Nice query. Simple change to the ORDER BY clause to get items listed in ascending ordinal position has it suit my needs much better than the ORDER BY Table_Name, Column_Name.

I once worked in an organization where the top manager in the company idolized Steve Jobs (including the unsavory A-hole that Mr. Jobs seems to have been). This guy had...

I will go either way depending on which of the two options I believe will be the "more normal mode". If my expectation is that most items will be active...