Not that I don't admire Jeff's abilities, but he doesn't speak the language sometimes... or better stated, he speaks the language of database.

From the perpsective of every coder, here's the difference.

Instead of a For Each loop on each component of a collection, you attempt to perform an operation against the collection directly. So instead of a For Each row In (select) do y, you do Collection.DoY (value). It's not a direct comparison but it gets the idea across.

Here's why, though: In your average programming language, you're expected to do 90% of the work. In a database engine, 90% of the work is done for you if everything is setup correctly. From there, properly defined and organized, all you need to do is tell it to do what you want in a single attempt to everything you want it to work against. The complications come in during setup, which is why the majority of us are here to attempt to help. 🙂