Excel Table Names
What are some of the best practices for naming your tables in Microsoft Excel? The website Excel Campus […]
Blog
Excel Pivot Tables Introduction
What are Pivot Tables in Microsoft Excel? First of all, let’s discuss tables. In Excel, a table is […]
Excel Power Query on YouTube
There are a lot of Excel Power Query tutorials on YouTube. Below is just a short list of […]
SQL Update one Table from Another
Are you working with an SQL database where you need to copy data from one table to another? […]
T-SQL Parsing a New Table
So far we’ve created a lot of new columns. These are only temporary columns because what we really […]
T-SQL Parsing Groups of 4
Since we are going to use PARSENAME to process/parse the string, and it works with a maximum of […]
T-SQL Parsing One Fruit per Column
Below is the code to add the new columns. Each fruit must ultimately be in its own column, […]
T-SQL Parsing Better Queries
Now that we have finished “normalizing” our fruits, we can write much better queries against the data. We […]
T-SQL Parsing To Get Frequency
This post is about determining just how many parts there are in a string that is delimited with […]
T-SQL Parsing Fruit Script
Below is the full script that you can use on your non-production server. This script is based on […]
SQL Find Nth Occurrence of Char in a String
T-SQL’s CHARINDEX() function is useful for parsing out characters within a string. However, it only returns the first […]
T-SQL Parsing Into Many Columns
This post is about working with one column in a SQL Server table that contains a comma-separated list […]