Calling a Stored proc within a stored proc 
Author Message
 Calling a Stored proc within a stored proc

Please send me some samples or reference sites on how I can call a Stored
procedure within a stored procedure.

Thanks in advance
--
Regards
Prakash Dharan
FXA Software Technology (I) Pvt. Ltd.,
Chennai. India
Phone : 91 - 44 - 2200928

 "Count your life by smiles, not tears. Count your age by friends, not
years."



Mon, 13 Dec 2004 11:05:49 GMT
 Calling a Stored proc within a stored proc

Within the stored procedure, add the following command:

_____________________
Join and Promote your skills at http://www.ciquery.com


Quote:

> Please send me some samples or reference sites on how I can call a Stored
> procedure within a stored procedure.

> Thanks in advance
> --
> Regards
> Prakash Dharan
> FXA Software Technology (I) Pvt. Ltd.,
> Chennai. India
> Phone : 91 - 44 - 2200928

>  "Count your life by smiles, not tears. Count your age by friends, not
> years."



Mon, 13 Dec 2004 19:58:47 GMT
 Calling a Stored proc within a stored proc
Hi

I am assuming the other stored procedure that you want to
call will return an output value...

In that case just use the syntax (In the calling Stored
Procedure)


output

Anand

Quote:
>-----Original Message-----

>Please send me some samples or reference sites on how I
can call a Stored
>procedure within a stored procedure.

>Thanks in advance
>--
>Regards
>Prakash Dharan
>FXA Software Technology (I) Pvt. Ltd.,
>Chennai. India
>Phone : 91 - 44 - 2200928

> "Count your life by smiles, not tears. Count your age by
friends, not
>years."

>.



Mon, 13 Dec 2004 11:36:18 GMT
 Calling a Stored proc within a stored proc
My case if the stored procedure returns a set of records or just one record.

Can I open a cursor with a storedprocedure in this case ?

Please advice..

--
Regards
Prakash Dharan
FXA Software Technology (I) Pvt. Ltd.,
Chennai. India
Phone : 91 - 44 - 2200928

 "Count your life by smiles, not tears. Count your age by friends, not
years."


Quote:

> Please send me some samples or reference sites on how I can call a Stored
> procedure within a stored procedure.

> Thanks in advance
> --
> Regards
> Prakash Dharan
> FXA Software Technology (I) Pvt. Ltd.,
> Chennai. India
> Phone : 91 - 44 - 2200928

>  "Count your life by smiles, not tears. Count your age by friends, not
> years."



Tue, 14 Dec 2004 04:12:20 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Calling a stored proc within a stored proc

2. Calling another stored proc within a stored proc

3. Need Help on Dynamic Stored Proc Call within Stored Proc w/OUTPUT

4. How to get results from Stored Proc within a Stored Proc

5. Exec store proc within a store proc

6. populating a temptable from a stored proc within a store proc

7. newbie trying to execute a stored proc from within a stored proc

8. Create large Stored proc from within stored proc

9. Stored Proc within a Stored Proc

10. Stored Proc Calling Another Stored Proc

11. How to call a stored Proc or Ext Stored proc /T-SQL UDF from VBScript

12. calling stored proc from stored proc via variable


 
Powered by phpBB® Forum Software