IT Professionals

[PARAMASHIVAN]

Sorry for the late reply Kirukan, been very busy at work. Thanks for your help, I have done it now. One more Question

Say you have Storeprcedure called SP1 with a variable called @orderno varchar(20) and you have another procedure called SP2 without any variables, can you call SP1 's variable into SP2 and excecute SP2. Is it some thing like this

Create proc SP2
as
Exec SP1,@orderno

??

Thanks in advance