Contents tagged with sql server clr

• Using ROW_NUMBER to get the most recent record from a table

  Friday, August 31, 2018 sql, sql server, sql server clr, foreign exchange No Comments
  

  Quite a while ago I wrote about using SQL Server CLR to add "earliest" and "latest" aggregate functions that could be used to retrieve the, well, earliest and latest Id values from a table based on …

  Read more...

  ---

• Using SQL Server CLR to add "earliest" and "latest" aggregate functions

  Saturday, August 19, 2017 sql, sql server, sql server clr No Comments

  Whilst there are undoubtedly very funky ways to achieve the same result, many moons ago I wrote a couple of SQL CLR aggregate functions for retrieving the earliest and latest values for a given …

  Read more...

  ---