Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
In this article we cover different ways to convert a SQL Server numeric value into a string value.
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.