Parse String into Table

This script takes a string of up to 8000 characters with a single character delimtier and returns a table with each substring in its own row. A identity column is also returned so you can easily find the n'th item in the list.Script is similar to kmlakov's but doesn't require the item count and adds […]

2006-02-21 (first published: )

1,239 reads

Blogs

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Blog Refresh – Growing Readers

By

Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...

Daily Coping 27 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSIS 2017 stopped running, not status is Pending Execution

By ConnieD

We have 3 sql agent jobs that are running SSIS packages.  Until this past...

cannot find MSOLEDBSQL driver for SSIS 2019 connection manager

By sqlfriend

In the list of connection manager driver, I cannot  find MSOLEDBSQL, There is a...

Lean Coffee

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lean Coffee

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers