i need to pass a temporary table from <BR> 1 stored proc to another as a parameter<BR> what is the sql for a parameter that is a temporary table <BR><BR> cheers in advance
You can do all your work in ONLY one SQL.
yes i can but if my stored proc has 400 parameters<BR>then i need to split it up<BR><BR> .. and it is cleaner to take all the parameters into 1 <BR> stored proc as they are all related
I did that before. But lots of troubles!!<BR><BR>You have to create a temp table & drop it.<BR>What about 2 or more peole run your page at that same time?<BR>The answer is: you have to create a table with dif. table names!!<BR>