However certain problems are less easy to describe in SET ORIENTED DML and really call for a RECORD ORIENTED approach. In specific cases a RECORD ORIENTED approach is an order of magnitude faster than a SET ORIENTED one.
Walter,
What's an example of one?
Have you looked at the new recursive query capability in SQL 2005 for working with hierarchical data?