>>In SQL Server 2008 you can pass a table to your SP and just insert into your main table using this table as a parameter.
>
>I have been thinking about that as well but everything is done without SP.

You cannot pass a table parameter from outside SQL Server anyway but you can pass your recordset as XML.