USP_SITEIMAGES_BULKPUTINTRASHBIN

CREATE procedure dbo.USP_SITEIMAGES_BULKPUTINTRASHBIN(@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=1, InTrashBin=1
    from dbo.SiteImages SP
    inner join @SiteImageIDS SPI on SPI.SiteImageID = SP.ID

END