Hello,

I currently use table functions in c#/.net for analytical table operations like aggregation, distribution, allocation, row-wise formulas, subtable transformation, etc.

Once I've implemented a function tree (which represent a quantitative model) using table functions, with data tables as input parameters, I can simulate the whole tree by varying some input values. I use such simulations for scenario analysis and optimizations.

A colleague advised me to use stored procedures instead of table functions for a better performance and scalability.

My first question is, why should I use stored procedures instead of table functions? What are their advantages over table functions?

Second question: Can I find a stored procedure library for analytical table operations?

Selina