I want to have a stored procedure which will accept a Datatable from .NET application and the tablename and will loop thru' each record in the Datatable and insert it into the table.
It will insert the bad records into a bad file.
Also how to send the datatable to the proc,what kind of parameter to use.
Pls post the code for this proc.
Thanks for your efforts.
Edited by: 817269 on Dec 15, 2010 5:52 AM