Qlikview | SQL Server | Power BI | Excel
The following post provides a few examples of how to add leading zeros to CHAR, VARCHAR and INT data type field values. I have to use these techniques quite often in my data world, so I figured it was a good post to share with others struggling with this task. Unfortunately, these techniques often result … Read more
I often get questions about joining tables in SQL queries. One particular question that comes up frequently is joining tables on multiple fields, when a user is trying to get unique matches based on the content of two fields. This post, SQL JOIN Multiple Tables with Concatenation, covers a simple example to illustrate this concept. … Read more
Transact-SQL (TSQL) Quick Tips – SQL CONCAT In many cases I need to bring together two separate fields to create a new field. Whether it be for display purposes, informational or joining to another table, the ability to combine two fields into one comes up frequently in my day-to-day work. Starting with SQL Server 2012, … Read more