Sprocs vs. inline calculations

[Fordian-Slip]

Hi Folks -

I am looking to get some thoughts on either best practices or speed
optimization ideas when it comes to generating a report that includes a lot of
calculations based upon records in a table.

I am wondering should I do this inline or all the calculations within a stored
proc?

To give a general idea... I have a yearly report that needs to calculate
totals based upon activity within a particual month.
January X Y Z
February X Y Z
etc...

Grand Total X Y Z

Thanks,

Doug

[dbahooker@hotmail.com]

you should use a sproc for everything

but i would just use plain sql over udf's or overly complex case when
then whenever you can

-aaron

[SQLMenace]

I would stored the aggregated values for past months in a Historical table
And join that table with the current month calculations so that you don't have
to recalculate the same static data every time someone requests this report
If you create a Stored Proc the query plan will be reused by the optimizer

[url]http://sqlservercode.blogspot.com/[/url]