Dynamic SQL application to refactor DBMS Sybase stored procedures within an insurance company

This article reviewing building of refactoring optimization methodology, created in process of medical and economical control of treatment for period. This article includes example of code simplifying and decreasing, using dynamic input and output data. Analysis of simplify the code support and optimization of medical and economical control lead-time are given as result.