1 2 3 4 5 6 7 8 9 10 11 12 13
| CREATE PROCEDURE stat.Question13ok()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE Num CHAR(6);
DECLARE cur1 CURSOR FOR SELECT NumDoss FROM stat.popucible GROUP BY NumDoss ORDER BY NumDoss;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1;
REPEAT
FETCH cur1 INTO Num;
INSERT INTO stat.Question13(NumDoss,Epworth,Epworth_1,Eva1,Eva1_1,datEntree2,datEntree2_1) VALUES ((SELECT p1.NumDoss FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 0,1),(SELECT p1.Epworth FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 0,1),(SELECT p1.Epworth FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 1,1),(SELECT p1.Eva1 FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 1,1),(SELECT p1.Eva1 FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 1,1),(SELECT p1.datEntree2 FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 0,1),(SELECT p1.datEntree2 FROM stat.popuCible p1 Where p1.NumDoss = Num ORDER BY p1.NumDoss, p1.DatEntree2 ASC LIMIT 1,1));
UNTIL done END REPEAT;
CLOSE cur1;
END $$ |
Partager