Hello! I have inherited a "LP_CUSTOMER_RANK" sproc that no longer performs as desired - it is assigning rankings that give discounts to customers not entitled to said discount. It has been through many changes in developers and business practices, and seems mostly made of band-aids at this point. I want to redo it, but at this point it is hard to tell what the current sproc is even doing. Do any of you fine Tessiturians have a "clean" copy of this stored procedure that you'd be willing to share as an example? Many thanks!
Payce, You can just put a RETURN statement (or un-comment it) before any code is executed. That is the default behavior. Send it over to me, I'm happy to take a look too.
JD
Thanks a million! I have emailed you the sproc.