USP_SITEPAGES_BULKMOVE

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

    set nocount on

    declare @SitePageIDS table ([SitePageID] int)
    insert into @SitePageIDS select IDS.ID.value('.', 'int') from @XML.nodes('/SitePages/id') IDS(ID)


    update dbo.SitePages SET
    FOLDERID=@FOLDERID
    from dbo.SitePages SP
    inner join @SitePageIDS SPI on SPI.SitePageID = SP.ID

end