Thursday, 22 January 2015
Thursday, 8 January 2015
SQL Claims Triangles
Insurance claims triangles, getting the latest outstanding amount and the total amount paid
Includes
Includes
- Temporary Tables
- Updating tables using a join
- While Statements
- Alter statements
SQL Earned Premiums for Triangulations
Query to generate earned premiums, working based off the latest of either the entry date or the inception date
Contains
Contains
- Temporary Tables
- Calculated Columns
- variables
- While Loops
Subscribe to:
Posts (Atom)