Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: sdv

Turning semicolon delimited data into a table

Here’s a handy conversion tool that I built for myself in order to convert semi-colon delimited data (very common in files, etc) into a table. It comes in the form of a scalar function, that converts a varchar(max) to an XML value.

Continue reading Turning semicolon delimited data into a table
Published 2013-04-21
Categorized as Intermediate, T-SQL Tagged convert, delimited, scalar function, sdv, semicolon, xml
sqlsunday.com
Proudly powered by WordPress.