Stored Procedure Question |
| Jason S posted at 03-Jul-08 09:37 |
I have a stored procedure that contains 60+ queries and about half of them are calculations that are 96 columns each. I was wondering what would be the best way to speed up the stored procedure? I do have one parameter for all of the queries but when the stored procedure hits the calculations, the process takes forever. Should I build that calculations in their own stored procedure and reference the stored procedure in my main stored procedure????? Lines of code is only around 1500 right now. Thanks in advance for assitance. Jason
|
|