I need some guidence on how to store resultes from a stored procedure(that generates a temporary table). I want to store these results into an AR for data manipulation in terms of making an ‘export to excel’ and generating interactive graphs and charts. The stored procedure pulls records from multiple tables with functions that produce an accurate date time and history of findings.
I guess I have a few questions on how to do this:
[list=1]
[*]Do I execute the stored procedure in a controller and store this into an array of ‘TampTable’ model?
[*]If so, what is the command to execute a stored procedure and how is that information returned?
[*]Is there a better way to do what I want to achieve?
[/list]
System setup(if this helps):
[list=1]
[*]SQL Server 2005
[/list]