USP_SITEIMAGES_BULKRESTOREFROMTRASHBIN

create procedure dbo.USP_SITEIMAGES_BULKRESTOREFROMTRASHBIN(@XML xml)
AS    
BEGIN

set nocount on

    declare @SiteImageIDS table ([SiteImageID] int)
    insert into @SiteImageIDS select IDS.ID.value('.', 'int') from @XML.nodes('/SiteImages/id') IDS(ID)

    update dbo.SiteImages SET
    Deleted=0, InTrashBin=0
    from dbo.SiteImages SP
    inner join @SiteImageIDS SPI on SPI.SiteImageID = SP.ID

END