Advertisement
18126

Untitled

Apr 10th, 2025
315
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.50 KB | None | 0 0
  1. DELIMITER $$
  2. CREATE procedure checkMonthTax(IN studId INT, IN groupId INT, IN paymentMonth INT, IN paymentYear INT)
  3. BEGIN
  4. DECLARE result char(1);
  5. SET result = 0;
  6.     IF( (SELECT paymentAmount
  7.         FROM taxespayment
  8.         WHERE student_id = studId
  9.         AND group_id = groupId
  10.         AND month = paymentMonth
  11.         AND year = paymentYear) IS NOT NULL)
  12.     THEN
  13.         SET result = 1;
  14.     ELSE
  15.         SET result = 0;
  16.     END IF;
  17. SELECT result AS IsTaxPayed;
  18. END$$;
  19. DELIMITER ;
  20. CALL checkMonthTax(1,1,1,2022);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement