Sir It is the problem that rouins me

Sir I am using Sql Server as my Db.
In Stored Procedure of Sql Server
I want to pass a table as an argument
 No I am achieving this by creating duplicate table and first
saving to there and taking from there by an Id
   or
using Array

but I did't think it is a proper method so I want to pass
a table (may be a recordset in vb)or a dataset table in .net
I am using .net is my front end.

Expecting Immediate Reply

With Regards
  C T Ranjith

V. useful sample code posted at Oracle FAQ:

http://www.orafaq.com/msgboard/oem/messages/1252.htm


Gokulan Ethiraj

Please present the case more clearly. My undesrtanding say that u r getting the Table name dynamically at run time.

U can declare a Table type local variable for ur stored procedure. If not very comfortable the u can pass the Table name as a Varchar data type. Using this table name, u can form a Query inside stored procedure and use EXECUTE method to fire the Formed query. Through this u can even get Output parameters as well.

Hope u got the idea if I am taking ur case correctly.



B. Anant

Actually I need to pass values it may contain so many columns like saving a master details and item details with in a procedure
so we have more item details. these details can have more rows and columns i need to pass it to an sql server two options for this is using a temp table or by an array but I did't think is it is so good, that is why i am searching for a better solution

expecting reply
yours thankfully

C T Ranjith

Yet, doesn't look clear for me. Can you elaborate, what exactly you would like to achieve?

_________________________
- Vijay G
Strive for Perfection