1 files changed, 17 insertions, 0 deletions
diff --git a/sql/proc_get_act_most_used.sql b/sql/proc_get_act_most_used.sql
new file mode 100644
index 0000000..e0a4674
--- /dev/null
+++ b/sql/proc_get_act_most_used.sql
@@ -0,0 +1,17 @@
+DELIMITER //
+DROP PROCEDURE IF EXISTS get_act_most_used//
+CREATE PROCEDURE get_act_most_used()
+BEGIN
+	DECLARE a CHAR(80);
+	DECLARE done INT DEFAULT FALSE;
+	DECLARE cur1 CURSOR FOR SELECT name FROM Resources;
+	
+	OPEN cur1;
+	
+	read_loop: LOOP
+		FETCH cur1 into a;
+		IF done THEN
+			LEAVE read_loop;
+		END IF;
+	END LOOP;
+END;