USP_CUSTOMFORM_BULKRESTOREFROMTRASHBIN

create procedure dbo.USP_CUSTOMFORM_BULKRESTOREFROMTRASHBIN(@XML xml)
AS    
BEGIN
  BEGIN TRAN        
  set nocount on
  UPDATE CustomFormSettings SET InTrashBin=0 WHERE FormGuid in
 (SELECT GUIDS.GUID.value('formGuid[1]', 'uniqueidentifier') from @XML.nodes('/CustomForms/CustomForm') GUIDS(GUID))                
  COMMIT TRAN    
END