Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL T-SQL Question: Stored Procedure with variables and exec statements RE: T-SQL Question: Stored Procedure with variables and exec statements

  • January 22, 2018 at 7:19 am

    #1976720

    ChrisM@Work - Monday, January 22, 2018 4:08 AM

    Asim Yousaf - Monday, January 22, 2018 3:06 AM

    use fnsplit tabular function . with ';' and a separated parameter. 
    <<snip>>

    The "house" splitter is likely to perform much better:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    It isn't likely to perform better. It will blow the doors out of that loop based splitter. This is like comparing a Yugo to a Porsche.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/