-dynamic- function to convert several rows of a table to a csv list

• Jeff Moden

  SSC Guru

  Points: 1004596

  More actions

  Follow

  July 11, 2008 at 9:43 am

  #841626

  Of course your CLR function is going to beat the T-SQL function... you used RBAR on steriods... you need to test against a correctly written T-SQL function for this to be a valid test. I'll provide two different UDF's for addition testing, if you'd like, but using a While loop against a CLR isn't a real test of if a CLR is faster or not.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• smerg

  SSC Veteran

  Points: 230

  More actions

  July 16, 2008 at 1:09 am

  #843551

  Hi all,

  thanks for all the replies...

  Best Regards

  Smerg

• suzman

  SSC Rookie

  Points: 29

  More actions

  October 13, 2014 at 10:08 am

  #1752030

  I was struggling with how to tackle this type of problem in T-SQL until I came across your sample code Jeff.

  What can I say?

  A bloody marvelous and timeless piece of T-SQL. It does exactly what I want it to do and I've learned something new in the process.

  Thank you.