Performace Issues with stored Procedure
Hi,
In my application i have around 5000- 6000 records that get updated through a stored procedure on a daily basis.
Now I have a requirement where I to insert this data into some other new tables.
Iam planning to use one more stored procedure that will be called within the first stored procedure.
Will there be any performance issues?If yes, is there any method I can implementsuch that I have to call only one storedprocedure from UI?
Any help would matter a lot
Regards,