Post reply

Split csv records to seperate columns

  • June 17, 2014 at 12:18 am

    #1722133

    Jeff Moden (6/16/2014)

    ykonline (6/13/2014)

    As per requirement we are not supposed to use UDF

    I suspect the people that made that requirement don't know that UDFs have 3 forms, one of which (the iTVF or "Inline Table Valued Function") will run just as fast as any "regular" code. The DelimitedSplit8K function is one of those.

    And, to be honest, anyone that allows the use of a WHILE loop for such things over using a good iTVF, probably shouldn't be writting the requirements. I strongly urge you and the folks spitting out the requirements to do a much deeper study of iTVFs before making blanket statements like "not supposed to use UDF".

    Here's one article to get you and those other people started.

    http://www.sqlservercentral.com/articles/T-SQL/91724/

    +1

    There is no reason not to use the DelimitedSplit8K function.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply