November 25, 2013 at 12:15 pm
I have a store proc which not only creates the table but inserts data in that table everytime it executes.
So the Store proc USP_ABC when executed creates table TBL_ABC and inserts data. for the first time.
from second time onwards , its checks if the table name is there and if yes will only only enter data (Not recreate).
Now if I have to create a chart based on the data in the table.Will I have to execute the store proc too?
How many datasets will I have to create..Will I create one Dataset for tabl only ??or two, one for store proc and the other for table.
P.S : Its not a temporary table .
December 2, 2013 at 2:55 pm
Do you expect the chart and the data table to have up to date information? If so, they you would need to execute the stored proc when the report runs. You should be able to use one table for both the chart and the data table.
December 2, 2013 at 3:23 pm
Why do you need to create a table in SQL Server at all for this? You can base your report on a stored procedure and you're off to the races. Is there a reason you need to populate a table to do this?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply