Kevin
>One other point - generating SQL code inside of the application really hurts the chance of reusability in other applications hitting the same database.
>By placing the code in a stored proc, the level of difficulty in exposing this as an API to multiple applications does down.

Any layered approach should minimze the hurt<g>. The ease of testing you posted elsewhere on is for me a less of an issue as dynamic environments are easier testbeds.

For me this "challenge" resulted in the following tick points:

MS-Sql in this task was not "better" as much as another thread hinted at

Using enhancements of SQL makes sense from a coding difficulty POV

coding such enhancements mean at least partial lock-in, so one good approach to minimize damage would be to isolate such usage.

While not an arguement against SP per se, the above point is a strong argument in favor of either code generation or generated SP's.

my 0.02 EUR

thomas