I wondered about this... with the advent of CROSS APPLY and a well written While Loop like what Alexey Eliseev wrote on this thread, a While Loop solution looks like it beats a pure Tally table solution on full table CSV's... but I'll show you why it fools most people.
--Jeff Moden
Change is inevitable... Change for the better is not.