USP_CUSTOMFORM_BULKDELETE

create procedure dbo.USP_CUSTOMFORM_BULKDELETE(@XML xml, @CurrentUsersID int)
AS        
  BEGIN TRAN        
    set nocount on

    declare @CustomFormGuids table (formGuid uniqueidentifier)
    insert into @CustomFormGuids select GUIDS.GUID.value('formGuid[1]', 'uniqueidentifier') from @XML.nodes('/CustomForms/CustomForm') GUIDS(GUID)

    declare @currentGuid uniqueidentifier
    while exists(select * from @CustomFormGuids)
    begin
      select top 1 @currentGuid = formGuid from @CustomFormGuids
      exec spCustomFormElement_DeleteByGuid @Guid = @currentGuid, @CurrentUsersID = @CurrentUsersID
      delete from @CustomFormGuids where formGuid = @currentGuid
    end


  COMMIT TRAN