Software guru, Inc

Real World Solutions

The Guru's Blog

By Jerry on 1/20/2013 4:44 PM
SQL Server is a great product that many clients begin using when they want to automate a lot of work previously done in Excel and Access.   People are amazed at the ease and speed at which SQL handles incredible volumes of data that would bring Excel to its knees.  Unfortunately, there are a lot of Excel functions for which there are no equivalent functions in Transact-SQL, and which are very hard to write in t-SQL.  The answer, of course, is write them in SQL CLR, a .Net assembly callable from SQL Server as an extended stored procedure.  But who has time to write Accrual and BondInt functions, or string functions?  The people at WestClinTech do.  
You must be logged in and have permission to create or edit a blog.