Query to pivot and stuff information to show all values
Insurance claims triangles, getting the latest outstanding amount and the total amount paid
Includes
- Temporary Tables
- Updating tables using a join
- While Statements
- Alter statements
Query to generate earned premiums, working based off the latest of either the entry date or the inception date
Contains
- Temporary Tables
- Calculated Columns
- variables
- While Loops