CLR Table-valued function

• KeiserSoze

  SSC Rookie

  Points: 35

  More actions

  June 12, 2008 at 3:48 am

  #827722

  I have a great example to be potentially implemented using CLR.. I have implemented T-SQL already but due complexity of stuff that needs to be done will do CLR implementation and will make a post about this as soon as I find enough time to prepare creation scripts... maybe some of you can help me to open my eyes towards things I have missed writing T-SQL and maybe some of the stuff can be done better.

  Regards!

  P.S. nope...i'm not doing FT here but it's pretty much complex and would like to see if that can be written more optimized then it is.

• HYDNIZ

  Say Hey Kid

  Points: 699

  More actions

  June 16, 2008 at 3:36 pm

  #829521

  The other thing I can add is the array manipulation. I made my mathematical calculations from an array. I can use CLR from either .net program or part of T-SQL procedure.

  Thanks

• Jeff Moden

  SSC Guru

  Points: 1004301

  More actions

  June 16, 2008 at 9:27 pm

  #829583

  HYDNIZ (6/16/2008)

  ---

  The other thing I can add is the array manipulation. I made my mathematical calculations from an array. I can use CLR from either .net program or part of T-SQL procedure.

  Thanks

  As you suggest, psuedo arrays are available in T-SQL, if you put your mind to it...

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

  --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)