#esprocspl Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Problem description & analysis: There are four strings separated into two parts by vertical bar, namely: ID|DUE_DATE, 80781|2026–12–01, VARCHAR2|DATE, |yyyy-mm-dd.Task: Now we need to...

08.04.2025 0 Read More

Number Non-Null Values in Order within the Group — From SQL to SPL #17

Problem description & analysis: After sorting a table in the Oracle database according to the first and second columns, the third column has non-null values. Task: Now we need to add a ca...

10.04.2025 0 Read More

Get the Records after and before the Searched One — From SQL to SPL #18

Problem description & analysis: The ProductionLine_Number in a certain table of the Mariadb database is a grouping field, and there are duplicate values in the Cardboard_Number field with...

13.04.2025 0 Read More

Find the Superset from the Relationship Table — From SQL to SPL #19

Problem description & analysis: The MySQL database has two tables: bag table and bag item relationship table. Some bags are supersets of other bags.bagbag_itemTask: Now we need to find th...

15.04.2025 0 Read More

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Problem description & analysis: SQL Server has two tables, Table1：Table2：Task: Now we need to sort Table1 by ID and traverse each record in sequence: retrieve the record in Table2 tha...

17.04.2025 0 Read More

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Problem description & analysis: Each column of database table tempdata can be viewed as an array, with duplicate members:Task: Now we need to group and count each column separately, in JS...

23.04.2025 0 Read More

Count Date Ranges per Year — From SQL to SPL #23

Problem description & analysis: The x field of the database table example is ID, and the ts field is the time interval.Task: Now we need to count which years are included in the time inte...

26.04.2025 0 Read More

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Problem description & analysis: The database table organisation_user_link stores the current state of the account, where dossier_created is the account creation time.The database table or...

28.04.2025 0 Read More