---
title: "esProc (@esProcDesktop) | Hashnode"
description: "esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engin..."
url: "https://hashnode.com/@esProcDesktop"
---

@esProcDesktop

# esProc

@esProcDesktop · Joined April 2022

[Website](https://www.esproc.com/download-esproc)

### [Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43](https://esproc-desktop.hashnode.dev/query-the-records-closest-to-the-specified-time-each-day-from-sql-to-spl-43?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: A table in Oracle database has a column of datetime type, corresponding to multiple pieces of data per day: Task: Now we need to find two records every day, one closest to 8am that day and one closest to 8pm that day....

1 min read · [esproc-desktop.hashnode.dev](https://esproc-desktop.hashnode.dev/query-the-records-closest-to-the-specified-time-each-day-from-sql-to-spl-43?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/query-the-records-closest-to-the-specified-time-each-day-from-sql-to-spl-43/685ca1705075534086cab4c4) [Jun 26, 2025](https://hashnode.com/posts/query-the-records-closest-to-the-specified-time-each-day-from-sql-to-spl-43/685ca1705075534086cab4c4)

### [Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42](https://esproc-desktop.hashnode.dev/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: A certain table in the MS SQL database has three fields: account, date and time of string type. Task: Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one ho...

2 min read · [esproc-desktop.hashnode.dev](https://esproc-desktop.hashnode.dev/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42/6858e9059546d8843d236553) [Jun 23, 2025](https://hashnode.com/posts/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42/6858e9059546d8843d236553)

### [Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41](https://esproc-desktop.hashnode.dev/row-to-column-conversion-involving-uncertain-columns-from-sql-to-spl-41?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: The query results of the Postgresql database return 6 columns, with the first column being the grouping column, the second column being the Value column within the group, and columns 3–6 being the Key columns within th...

2 min read · [esproc-desktop.hashnode.dev](https://esproc-desktop.hashnode.dev/row-to-column-conversion-involving-uncertain-columns-from-sql-to-spl-41?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/row-to-column-conversion-involving-uncertain-columns-from-sql-to-spl-41/6854e21cb5a9ccbfe54b01e0) [Jun 20, 2025](https://hashnode.com/posts/row-to-column-conversion-involving-uncertain-columns-from-sql-to-spl-41/6854e21cb5a9ccbfe54b01e0)

### [Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40](https://esproc-desktop.hashnode.dev/search-for-records-containing-a-specified-string-group-in-multi-fields-from-sql-to-spl-40?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: A table in an Oracle database has multiple string fields. Task: Now we need to input a parameter that contains multiple strings separated by commas. We need to find the records in the table that contain all these stri...

2 min read · [esproc-desktop.hashnode.dev](https://esproc-desktop.hashnode.dev/search-for-records-containing-a-specified-string-group-in-multi-fields-from-sql-to-spl-40?utm_source=hashnode&utm_medium=feed)

[Jun 18, 2025](https://hashnode.com/posts/search-for-records-containing-a-specified-string-group-in-multi-fields-from-sql-to-spl-40/68523420c2aee23b0caa5a19)

### [Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39](https://esproc-desktop.hashnode.dev/add-records-that-meet-the-criteria-before-each-group-after-grouping-from-sql-to-spl-39?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: In a certain view of the PostgreSQL database, the row\_index field is an underscore separated string and also a grouping field. Some groups’ row\_index can be divided into 3 parts, while others can be divided into 2 part...

2 min read · [esproc-desktop.hashnode.dev](https://esproc-desktop.hashnode.dev/add-records-that-meet-the-criteria-before-each-group-after-grouping-from-sql-to-spl-39?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/add-records-that-meet-the-criteria-before-each-group-after-grouping-from-sql-to-spl-39/684f8f1177ed991dcfbd293a) [Jun 16, 2025](https://hashnode.com/posts/add-records-that-meet-the-criteria-before-each-group-after-grouping-from-sql-to-spl-39/684f8f1177ed991dcfbd293a)
