USP_EMAILLIST_BULKMOVE

create procedure dbo.USP_EMAILLIST_BULKMOVE
(
@XML xml,
@SITEFOLDERSID int
)
as
begin
    -- do work

    set nocount on

    declare @EMAILLISTIDS table ([EMAILLISTID] int)
    insert into @EMAILLISTIDS select IDS.ID.value('.', 'int') from @XML.nodes('/EmailLists/id') IDS(ID)

    update dbo.EMAILLIST set
    SITEFOLDERSID=@SITEFOLDERSID
    from dbo.EMAILLIST EL
    inner join @EMAILLISTIDS ELI on ELI.EMAILLISTID = EL.ID    
end