esProc Desktop's Blog
Tag

esProc SPL

#esproc-spl

More content

Read more stories on Hashnode

Articles with this tag

Search for the Closest Matching Record within the Group — From SQL to SPL #9

Mar 12, 20252 min read

Problem description & analysis: The table mytable in the MS SQL database has one ConfirmationStarted and multiple Closed statuses for each ID. Task:...

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

Mar 10, 20253 min read

Problem description & analysis: The id and nbr of the MS SQL database table are grouping fields. After sorting the records within the group by time...

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

Mar 5, 20252 min read

Problem description & analysis: The MS SQL database has an externally generated non-standard table that generates N pairs of fields and one record at...

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

Mar 3, 20252 min read

Problem description & analysis: The MySQL database has a sampling table, where each ITEM and CITY is a sampling task. Each sampling task includes 1 to...

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

Flexible Interval Aggregation — From SQL to SPL #5

Feb 27, 20252 min read

Problem description & analysis: The range of the ID field in a table of Oracle database is integers 1–2000. Task: Now we need to group IDs into...

Flexible Interval Aggregation — From SQL to SPL #5

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

Feb 25, 20252 min read

Problem description & analysis: A table in the SQL Server database can be seen as a cross table, where the combination of the first two field values...

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4