October 6, 2004 at 1:08 am
Hi All,
I need to pass recordset as a prameter to procedure. Can any one help me out.
Can we use tabel variable (alternate to recordset) as a parameter to procedure ???
Thanks,
Snehzz
October 6, 2004 at 1:55 am
You can use a temporary table (not a table variable) or a delimited string.
Razvan
October 6, 2004 at 7:03 am
Are you using ADO,OLE DB, or some other DB access architecure?
What language? VB,C/C++, PHP, JAVA, other...?
October 6, 2004 at 10:06 pm
Hi Thanks for reply,
I agree with Joe... post the problem...
So the problem is I have couple of procedure. One is master procedure and other procedure is called from the master procedure. I do some calculation and other stuffs in the master procedure and then depending on all the calculations i create a select statement. Now the resultset of the statement i want to pass it to all the child procedures.
I thought it will be nice to pass a recordset to all the procedure. as i need to do some calculation in each procedure on recordset. All the child procedure updates some table.
Once all the child procedure are executed. Then again in master procedure i need to do some calulations.
October 7, 2004 at 10:23 pm
Hi Joe.... thanx...for the reply... can u suggest some good book / link to refer for design methodology....
Yep i dont create dynamic sql in procedure.... but i want to pass that resultset to all other procedure.... what should i do... shall i reverse the things... i will create a procedure which will return the resultset..... all those child procedure will call that procedure and do the updates....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply