Great idea, providing you are using ADO.

Being a SQL Server guy it is very easy to get into the Microsoft mentality. JFDI methodology.

We use a variety of Web Content Management Systems and they can only handle the bare minimum of ODBC functionality. Certainly not multiple recordsets.

I have invented a whole new dictionary of swear words over a CMS that did not support OUTPUT parameters, including RETURN_VALUE!