swoozie (4/14/2014)
Well in this shop, data is stored and these are the topics I have to report off of. All SQL, no front in application to sit on top.Simple Depreciation is easy to calculate, and store. the rest I am still looking, hopefully someone out there has had to do this.
SQL Server does not have these built in functions for complex accounting calculations. You have to calculate and store this information yourself.
Things like Cost Analysis and Expense Forecasting are immensely complicated and have lots and lots of business rules for each company that wants this type of thing. You can write all of that into a stored procedure or something but you have to first identify what those rules are.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/