The Guru's Blog Excel Functions inside SQL Server Stored Procedures 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. PermaLink Read More » Comments (11) Jerry Langland's Blog
Tags Delphi (3)CLR (2)WestClinTech (2).Net (1)7-Zip (1)ARECA (1)Authentication (1)DevExpress (1)Eventlog (1)Excel (1)Hard Disk (1)IE (1)Iomega (1)legacy data (1)MS Office (1)MSMQ (1)OAuth1 (1)Open Authentication (1)RAD Studio XE 5 (1)RAID (1)RDS (1)RESTClient (1)SQL (1)STAC (1)STAC Electronics (1)Stacker (1)StacVol.dsk (1)Telerik (1)Terminal Services (1)Time Zone (1)Tumblr (1)Twitter (1)Visual Studio (1)Zip Drive (1)