Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jasraja
Starting Member
22 Posts |
 Posted - 2009-06-03 : 07:42:26
|
| Do we have pricing functions (like PRICE(), ACCRINT(), YIELD() etc in Excel 2007) available in SQL Server 2005?If not how can I call Excel Pricing functions from SQL Server 2005?Please let me know if there exists any alternate way to achieve the purpose.Any help/support will be highly appreciated.Jasraja |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-03 : 11:16:02
|
| HiThese functions are not available in SQL Server 2005 or 2008.The only way to use them is using CLR, If you are familiar with .NET code, It would be easy for you.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-06-03 : 12:56:50
|
| Excel is good at documenting the formulas they use for their functions so you can always write your own t-sql versions or find someone that already has.Be One with the OptimizerTG |
|
|
|
|
|
|
Pricing functions