Following is the sql query to insert multiple rows to a table at a time.
Insert INTO Table1(Col1, Col2, Col3)
Values('a','b','c'),
('x','y','z')
You can wrap it into a stored procedure and can pass multiple rows values by comma separated as a parameter.