TSQL Stored Procedure to disable failing jobs

Procedure to disable failing jobs and email an alert when this happens

SQL Pivot and Stuff

Query to pivot and stuff information to show all values 

SQL Claims Triangles

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

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

• Temporary Tables
• Calculated Columns
• variables
• While Loops