>Hi Naomi. Many thanks for replying > >>>>>Do you want to pass a name of the parenttable or the table itself? >Not sure.... In effect I want to pass the 'Data' in, so not sure If I just need to pas the Name of the Table or the data..... I presume the data as I will need to use it in the Select inside of the stored procedure as the Table will not exist in the database.... it is being derived in a different way, based on resonses from a user > >Regards, >Gerard > >>Assuming the former, check >>http://blog.sqlauthority.com/2011/08/25/sql-server-tips-from-the-sql-joes-2-pros-development-series-table-valued-store-procedure-parameters-day-25-of-35/ >> >>for usage explanation from the SQL Server side.
In this case you will be passing data table as table valued parameter to Stored procedure. The blog above explains what needs to be done from the SQL Server side.
