Insert Multiple Records Using One Insert Statement

See more:

VB

ASP.NET

SQL-Server

Hi, I want to insert multiple rows using one stored procedure.
my current insert statements like that

squery = "insert into pricing values('I', getdate(), 'msg 0 goes here');"

squery += "insert into pricing values('B', getdate(), 'msg 1 goes here');"

squery += "insert into pricing values('C', getdate(), 'msg 2 goes here');"

sqlcommand.CommandText = squery
      Try
          sqlcommand.ExecuteNonQuery()

now i tried to switch to stored procedure it work if i am entering one record only but i can't get it to insert multiple

squery =InsertSP 'C', 'MSG'; 

squery +=InsertSP 'V', 'MSG'; 

it gives me error and tells me there is error in the syntax