(Print this page)

New article: Splitting a value into multiple rows in Microsoft SQL Server
Published date: Friday, April 26, 2019
On: Moer and Éric Moreau's web site

I just published a new article about a question I was answering on Experts Exchange. A simple question that comes back every so often.

The question was: how do I split the content of a value from a row into multiple rows?

I had to provide 2 answers. One useful only for the lucky who are using Microsoft SQL Server 2016 and above. And another one for the unlucky ones (but limited to SQL 2008).

You can read this article from https://www.emoreau.com/Entries/Articles/2019/04/Splitting-a-value-into-multiple-rows-in-Microsoft-SQL-Server.aspx

(Print this page)