I need a help from you all ,I have a big problem right now I am developing a stock market related site where I have to calculate XIRR return of investment and this is in built function of excel So wht I want is to take data from sql server insert that data in excel file there i want to calculate XIRR formula and then again retrive data from that excel and put it in again in sql server. I try to make that XIRR Function in sql server but it is taking too much time to execute.
Please can anybody helo me in this matter ??
Thanks well in advance.