USP_SITECONTENT_BULKRESOTREFROMTRASHBIN

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