Imagine there’re 2 tables, let’s call them “Master” and “Detail”: There’re 2 input parameters: list of Master IDs (master_id_list) and numeric value (num_value). For every ID in master_id_list I should get one Detail record: If num_value < MIN( f_value ), it should be the record with MIN( f_value ) If num_value > MAX( f_value ), it should be the record
Tag: firebird-3.0
Display all Dates in a given month and year in firebird select procedure
I am making a program for Time and Attendance. I have a table with this fields here is the sample data and my desired output is this the time format of my desired output and my data is different and display the complete dates of the given month and year Answer You could solve this problem with a selectable stored