Monthly Archives: January 2017

Set based vs row by row (procedural code)

I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide a more complete reference. To provide some context I am explaining the business case here. A hospital wants to identify people whose heights have changed over time… Read More »

Calculating Pi in MS SQL Server

PI is a very commonly used mathematical constant, in fact it is probably more famous than the equation E=MC2. We might not find a lot of use for it within the database community but it is a fascinating value to calculate and so we set out to do just that. First we tried using the… Read More »