USP_SITEIMAGES_BULKRESOTREFROMTRASHBIN

create procedure dbo.USP_SITEIMAGES_BULKRESOTREFROMTRASHBIN(@XML xml)
AS    
BEGIN
    BEGIN TRAN        
    set nocount on
    UPDATE SiteImages SET Deleted=0, InTrashBin=0 WHERE ID in
 (SELECT IDS.ID.value('.', 'int') FROM @XML.nodes('/SiteImages/id') IDS(ID))                
    COMMIT TRAN    
END