Write stored procedure as below
CREATE PROCEDURE sp_InsertSerialNumber
(
@Id UniqueIdentifier ,
@Name NVARCHAR(255),
@SerialNo NVARCHAR(255),
@Price BigInt ,
@Location NVARCHAR(255)
)
AS
BEGIN
INSERT INTO Table1
SELECT @Id,@Name,@SerialNo,@Price
INSERT INTO Table2
SELECT @Id,@Name, @SerialNo,@Location
END
Hope this help
--Rahul