USP_SITEPAGES_BULKRESTOREFROMTRASHBIN

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