CMS recently published the FY 2022 Inpatient Prospective Payment System (IPPS) Proposed Rule which includes several proposed changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare Promoting Interoperability Program for eligible hospitals and critical access hospitals (CAHs). For the full text of the rule, see the Federal Register.
So, in plain English, what is a T-SQL user-defined function? A function is a SQL query saved as a database object, which leverages and outputs data to serve a focused purpose. Once a function is created it easily can be utilized at any time by anyone with proper access. Measured creation and execution of functions will greatly streamline data production from your T-SQL environment, allowing technology to do what it’s supposed to - make our lives easier! Let’s start with a simple example to better explain why we should be using functions and illustrate different types.