Splitting a range string into a table

2014-03-162018-07-15 / Daniel Hutmacher / Leave a comment

This week’s post is a requirement that I see very regularly as a developer. You get a plaintext string containing one or more ranges. Each range is comma delimited, and the start and end values of the range are separated by a dash. The string could look something like this, for example: 100-120,121-499,510,520,790-999.

Wouldn’t it be practical if we could construct a table value function that returns one row for each range, with columns for the start and end of each range?

Continue reading →

A function to parse ranges

2013-06-022018-07-15 / Daniel Hutmacher / 2 Comments

Here’s a quick function to parse a list of ranges (in a varchar variable) into a table of ranges. Might come in practical, for instance when parsing user arguments for a report.

Continue reading →

Basic string parsing

2013-02-17 / Daniel Hutmacher / Leave a comment

A lot of times, T-SQL queries aren’t just for compiling huge sets of aggregate calculations or advanced joins and indexing strategies. Sometimes, you need the skills and tools to do some basic string parsing. Here, you’ll learn the most common basic string parsing and functions found in T-SQL.

Continue reading →

sqlsunday.com

T-SQL tips and tricks, best practices and query plans from the field.

split

Splitting a range string into a table

A function to parse ranges

Basic string parsing