(Parthasarathy Mandayam) You already know that stored procedures offer enormous benefits over direct SELECT statements. But one of the things you tend to have to sacrifice when you replace a simple SELECT with a stored procedure is direct control over the resultset.
Read More - Register for Free Membership