Stored Procedure hi, Can we execute a stored procedure inside another stored procedure?Plz help me urgently. . . . . Hi, yes you can execute another Stored Procedure inside a stored procedure. you can use it like this. . create procedure [StoredProcedure1] as exec

Return table from Stored Procedure into another stored procedure SQL Server hi, can this be done? i have stored procedure 1 that calls stored procedure 2 in the FROM clause. Stored procedure 2 is supposed to return a table. For

stored procedure hi, i used stored procedure to display data in gridview, i just worte only select query in stored procedure. . .its working well. now using that stored procedure shall i select particular data using where clause. eg: stored procedure name:total amount. sqldataadapter

2 result sets and stored proc SQL Server Hi, I have a stored proc (proc 1) that returns 2 result sets. How can I capture them with another stored procedure (proc2). I need to be able to call Proc1 from whithin proc2 and use those results sets in proc 2. Thank you, T. SQL Server Discussions SQL Server (1) Stored procedure (1) Exec (1

calling SSIS from Stored Procedure with stored procedure variables I would like to call SSIS Package from stored procedure and pass one parameter to SSIS package from stored procedure which gets generated automatically. how can I do that? can I set SSIS package variables