jeaux:

With so small of queries in each SP there is no advantage I know of to use what I showed in my article over what you just posted.

The advantage comes when you have 2,000 or more lines of code for each query using complex SELECT, FROM, WHERE, and ORDER BY clauses and possibly using GROUP BY and HAVING as well. Then it can be easier to maintain to have seperate stored procedures instead of using the technique you used.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.