T-SQL Parsing Better Queries
Now that we have finished “normalizing” our fruits, we can write much better queries against the data. We […]
SQL Server
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 […]
SQL Combining Two Tables
This post is about combining the data from two tables by adding columns, not rows. Here we think […]
SQL Server Table Variables
What is a table variable and when would you need to use it? A table variable is a […]
T-SQL Count Character Occurrences
Do you have a table in SQL Server that has a column with a string that has several […]
T-SQL Parse a String 2
In this post I’ll discuss how to parse a string in SQL Server so that you can move […]
T-SQL Parse a String
In SQL Server, do you have a table with a column that has several values in it that […]
SQL Select Distinct
Sometimes a column in a table has repeating values and you want to know what the list of […]
SQL Count NULLs
How many NULLs are there in a column? What would the SQL query be? For small tables you […]