Datos xml

Espero que te sirva!. Si no sabes como usarlo, avisame y te explico paso a paso
/*
Updates language info for a user
Input parameter is XML formated list of items.
*/
CREATE Procedure PERS_update_Language_list
@UserId numeric,
@LanguageList ntext
as
DECLARE @idoc int;
EXEC sp_xml_preparedocument @idoc OUTPUT, @LanguageList;
declare @PersLanguageId numeric;
declare @LanguageId int;
declare @LanguageLevelId int;
declare crs cursor for
SELECT PersLanguageId, LanguageId, LanguageLevelId
FROM OPENXML (@idoc, '/ROOT/Language',1)
WITH ( PersLanguageId numeric,
LanguageId int,
LanguageLevelId int
);
begin tran _tran;
delete from persLanguages
where userId = @userId
and not PersLanguageId in (
SELECT PersLanguageId
FROM OPENXML (@idoc, '/ROOT/Language',1)
WITH ( PersLanguageId numeric,
LanguageId int,
LanguageLevelId int
)
where not persLanguageid is null
)
if( @@ERROR != 0 )
begin
rollback tran _tran
select '-1' as Result for xml raw
return -1;
end
open crs;
FETCH NEXT FROM crs into @PersLanguageId, @LanguageId, @LanguageLevelId
WHILE @@FETCH_STATUS = 0
BEGIN
declare @res int
if( @PersLanguageId is null )
exec @res = pers_add_language @userId, @LanguageId, @LanguageLevelId
else
exec @res = pers_update_Language @persLanguageId, @LanguageId, @LanguageLevelId
if @res < 0
begin
rollback tran _tran;
close crs;
deallocate crs;
select @res as Result for xml raw
return @res
end;
FETCH NEXT FROM crs into @PersLanguageId, @LanguageId, @LanguageLevelId
END
CLOSE crs
DEALLOCATE crs
commit tran _tran;
if( @@ERROR != 0 )
begin
select '-1' as Result for xml raw
return -1;
end
select 0 as Result for xml raw
return @userId;