Thursday, 22 January 2015

SQL Pivot and Stuff

Query to pivot and stuff information to show all values 

Thursday, 8 January 2015

SQL Claims Triangles

Insurance claims triangles, getting the latest outstanding amount and the total amount paid


  • 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


  • Temporary Tables
  • Calculated Columns
  • variables
  • While Loops