Categories
Database Development

stored proc – group by and summ

Good day – I got it right to get mysql to work like a pivot table – whoop whoop. What i am now struggling with is to get it to sum by grouped. please help. Here is my code DELIMITER $$ USE `pastel`$$ DROP PROCEDURE IF EXISTS `pivot_accmt_a`$$ CREATE DEFINER=`qadmin`@`%` PROCEDURE `pivot_accmt_a`(IN InvDate1 VARCHAR(255)) BEGIN […]

Categories
Database Development

Only return second result of mysql stored proc

Good morning. This is my first attempt at a stored proc and it works nicely. The only problem is stat it returns 2 reslults, the secon result is the one that i need to import into excell, or php. how di i limit this stored proc to only show the secon result or how can […]

Categories
Development

Jest matchers to check given set of special characters not available in string

I am trying to validate a string in which i have to check the not allowed special characters. if it contains not allowed special characters test case should fail. I tried matcher but it only accepts one args. I have a many not allowed special characters(eg:[‘@’,’`’,’!’]). Is there any jest matcher in which i can […]