Thanks everyone for the great comments and ideas. I should have been more explicit with the cautions for dropping objects. Of course, you would not just drop things...

Thanks for the ideas, Flo and John. I will probably think more seriously about creating another smaller development environment. It's always a trade-off - will the improvements that I...

Thanks for the comments. Some non-printing characters got in there - it should be fixed soon.

You can easily eliminate a lot of this type of conditional logic :

-- We should add the WHERE clause if at least one parameter

-- is non-null

IF @ProductNumber IS NOT NULL...

This looks like it could be really interesting, but there's bugs in the code. Lots of spaces are missing and cause syntax errors. Also, it needs to be...

Thanks, that's a good idea. As a matter of fact, it's made me realize I might be able to have it all in one function - just by having...