hello sir,
I am the system Administrator in manufacturin company.I want to write down the stored procedure.I can't understand how i do this.
Data comes from 15 diffrent queries including 7 tables and it is stored in one table.After pressing 'Refresh' button from the frontend all the queries must executed and data are stored in the table called Plan41.At the front end side the data displayed from Plan41 table.
how i write down stored procedure for this?for this i have to write down the separate stored procedure for each query or all the queries are included in one stored procedure or anyother solution over this problem like can i do this by using trigger or anything else.
The main purpose for this is that to reduce the time for plan refresh.
send me solution as soon as possible


-Madhuri

hi

u dont have to write 15 procedures to execute 15 queries. u can execute all the queries in 1 procedure with proper error handling.
for the syntax part, u can search in Books Online

Ashu

combine all the queries in a single SP

get the work done

atul