[RESOLVED] Stored Procedure, how would you approach this?

[motil]

Hi,

in my projects I keep all my queries inside my database as stored procedures. one of the biggest problems with SP (in my opinion) is the lack of dynamically when using them, anyway so far i manage to handle this problem but now i came to a dead end, in one of my project pages i have to create a unknown number of INSERT statements, i know i can create one INSERT statement and call it x number of times, but for performance reasons I need to write the INSERT statement as follow (this is MySql Syntax but i think MSSQL is almost the same):

INSERT(column1,column2)VALUES(value1,value2),(value1,value2) ...

where there can be any number of values ... is there a good approach for this kind of operation using SPs ?

Thanks!