Home Forums SQL Server 7,2000 Administration Anyway to write VB/C#/C++ scripts in SQL 2000? Need financial calculations (IRR, NPV, etc) RE: Anyway to write VB/C#/C++ scripts in SQL 2000? Need financial calculations (IRR, NPV, etc)

  • January 8, 2013 at 11:08 am

    #1574942

    Lynn Pettis (1/7/2013)

    Have you looked at the OLE Automation procedures? That may do what you want, but I haven't used them.

    I looked through a few sites related to this, but I didn't see any practical way to use it for what i need. What I did do though was build a command line application in VB that when fed the values returns the financial result so I could use it via xp_cmdshell. Problem though unrelated to SQL is it uses interop, and I don't guess the SQL 2000 server has Excel installed :-/ I know running Excel on the server is less than ideal, but given the lack of financial functions in MS SQL there's not many other options.

    Sam