I use ASP.net as the front-end and MS SQL 2008 as Database Server. I am a newbie, have been trying to write a stored procedure which should take list of rows as input and do bulk insert, all at once (no multiple INSERT INTO).
I read up on Bulk Insert, but that takes data from flat files which cannot help my case.
Is there a better way to do this? Appreciate any help!