Occasionally I needed to choose the greatest or least value from a set of columns during a project in SQL Server and use that value to make another decision in my logic. For example, choosing the most recent or oldest date. Depending on how the data is modeled, this could be relatively simple and useContinue reading “SQL Server: Greatest and Least Functions”
Category Archives: SQL Server
Snowflake: Getting Started Stored Procedures
I’ve been primarily a SQL Server developer for the majority of my career, but along the way have needed to use a variety of database technologies including Oracle, Vertica, Teradata, PostgreSQL, and several others. A common behavior between them all is the ability to write some flavor of a stored procedure to encapsulate a blockContinue reading “Snowflake: Getting Started Stored Procedures”
Eric Heilman 