Let’s suppose one is tasked with a complex set of calculations where the input data loads from a database and the output data saves to a database. This has come up a number of times in my consulting work. There are 2 approaches: Use language of choice, read data, perform calculations, write data Work entirely …

Continue reading ‘Embedded procedural programming inside SQL Server Databases’ »