want to write a custom function

• vbandlamudi

  Mr or Mrs. 500

  Points: 542

  More actions

  April 9, 2009 at 2:28 am

  #130461

  I HAVE TO DO SOME DIFFERENT DATA TRANSFERMATIONS IN MY SQL STATMENT

  FOR THIS I WANT TO GO WITH A CUSTOM FUNCTION

  PLEASE HELP ME HOW TO WRITE A CUSTOM FUNCTION WHICH WILL WORK LIKE THE EXISTED AGGREGATE FUNCTIONS

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  April 9, 2009 at 4:27 am

  #974917

  http://francoisbeaussier.blogspot.com/2007/10/creating-custom-sql-aggregate-function.html

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 9, 2009 at 10:59 am

  #975240

  Please don't post in all caps. It's the online equivalent of shouting.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass