<Lista>
    <Language ID="1"/>
    <Language ID="2"/>
    <Location ID="3"/>
    <Location ID="4"/>
    <Type     ID="5"/>
    <Type     ID="6"/>
    <Type     ID="7"/>
</Lista>

CREATE PROCEDURE InsereazaPestiMarinati
  @x XML,
  @id INT
AS

INSERT INTO tblJobLanguage
SELECT @id AS JobID, Tabela.Info.VALUE('@ID', 'int') AS LanguageID
FROM @x.nodes('//Lista/Language') Tabela(Info)

INSERT INTO tblJobLocation
SELECT @id AS JobID, Tabela.Info.VALUE('@ID', 'int') AS LocationID
FROM @x.nodes('//Lista/Location') Tabela(Info)

INSERT INTO tblJobType
SELECT @id AS JobID,  Tabela.Info.VALUE('@ID', 'int') AS LanguageID
FROM @x.nodes('//Lista/Type') Tabela(Info)

Vrei ca inserarea sa se realizeze mai simplu / dintr-un singur INSERT ?