1 files changed, 0 insertions, 9 deletions
diff --git a/Gestor.Application.Migration.Files.20210825_174.SQL b/Gestor.Application.Migration.Files.20210825_174.SQL
deleted file mode 100644
index 3776d35..0000000
--- a/Gestor.Application.Migration.Files.20210825_174.SQL
+++ /dev/null
@@ -1,9 +0,0 @@
-DECLARE @sql NVARCHAR(MAX) = N'INSERT INTO vida (iditem, plano, obs) SELECT i.iditem, i.descricao, r.obs FROM item i INNER JOIN documento d on d.iddocumento = i.iddocumento INNER JOIN controle c on c.idcontrole = d.idcontrole INNER JOIN riscosdiversos r on r.iditem = i.iditem WHERE c.idramo = 47;'
-
-DECLARE @sqlDelete NVARCHAR(MAX) = N'DELETE FROM riscosdiversos WHERE iditem in (SELECT i.iditem FROM item i INNER JOIN documento d on d.iddocumento = i.iddocumento INNER JOIN controle c on c.idcontrole = d.idcontrole INNER JOIN riscosdiversos r on r.iditem = i.iditem WHERE c.idramo = 47);'
-
-IF EXISTS(SELECT 1 FROM item i INNER JOIN documento d on d.iddocumento = i.iddocumento INNER JOIN controle c on c.idcontrole = d.idcontrole INNER JOIN riscosdiversos r on r.iditem = i.iditem WHERE c.idramo = 47)
-BEGIN
-    exec sp_executesql @sql
-    exec sp_executesql @sqlDelete
-END
-\ No newline at end of file