Home Forums SQL Server 2008 SQL Server 2008 - General How to split varchar variable to multiple rows and columns based on two delimeter RE: How to split varchar variable to multiple rows and columns based on two delimeter

  • August 5, 2015 at 4:22 am

    #1817421

    Hi , Thanks for you update.

    I am looking for like a function to insert data like below instead of creating insert statement in your query.

    select Name,Value1,Value2,Value3 from functionSplitter(@var, '@','~')

    Thanks,