[2020-10-03 21:39:55] [Msg] Table Type - SQL script file
[2020-10-03 21:39:55] [Msg] Getting and Exporting data ...
[2020-10-03 21:39:55] [Msg] Export query [sp_suerte]
[2020-10-03 21:39:55] [Msg] Export to - C:\Users\gtz-j\Desktop\sp_suerte.sql
[2020-10-03 21:39:55] [Msg] 1193 - Unknown system variable 'num_id_dep'
[2020-10-03 21:39:55] [Msg] SQL: 
CREATE PROCEDURE sp_suerte()

BEGIN
Declare num_concurso INT;
Declare num_concurso_busca INT;
Declare num_concurso_buscamas INT;
Declare num_uno INT;

CREATE TABLE tmp_num (
	id_concurso			INT NOT NULL);


set num_concurso = (select MAX(id_concurso) from numeros);

set num_uno =(select uno_1 from numeros where id_concurso = num_concurso);

Insert Into tmp_num(id_concurso)
select id_concurso from numeros where uno_1 = num_uno order by id_concurso asc;

	WHILE num_row > 0 DO

		set num_id_dep = (Select id_dep from tmp_tree LIMIT 1);
		set num_node = (select max(node) from tmp_treeview);
		
		Insert Into tmp_treeview(nombre_doc,node, id_doc)
		Select DISTINCT nombre_cat, num_node + 1 , 0
		from tmp_view 
		Where id_dep = num_id_dep;  
		
		delete from tmp_tree
		where id_dep = num_id_dep;

		SET num_row = num_row - 1;
	END WHILE;

set num_concurso_busca = id_concurso + 1;

select num_concurso, num_uno;
select * from tmp_num;

drop table tmp_num;
End

[2020-10-03 21:39:55] [Msg] Finished - Unsuccessfully