ID ContactName1  Designation1 ContactName2 Designation2
1  A             dummy        B            sam

ID ContactName Designation

@ContactName1
@Designation1

@ContactName2
@Designation2

INSERT INTO DataTable (ContactName, Designation) VALUES
    (@ContactName1, @Designation1),
    (@ContactName2, @Designation2);

SELECT MAX(ID) AS max_id FROM DataTable

INSERT INTO Table(ID, ContactName, Designation)
    VALUES(1, @ContactName1, @Designation1)
    VALUES(1, @ContactName2, @Designation2);