esProc Community

Recent

Trae + SQLazy: A Practical Guide to Writing Complex SQL

2026/07/29 by sjr

Text2SQL Practice: what happens if you ask AI to write a few dozen lines of SQL?

2026/07/28 by ezpz

I Break Down a 100-Line SQL Script That No One Dares to Touch into 7 Steps

2026/07/28 by lisongbo

SQLazy: Order-Level Warehouse Assignment Based on SKU Conditions

2026/07/24 by jinxing

SQLazy: Calculate Original Inventory by Working Backwards from a Given Date

2026/07/22 by jinxing

SQLazy: Fill Field Values by Sequence Across Sub-Groups

2026/07/17 by jinxing

SQLazy: Identify Whether Differences Within Groups Come from Brand or Type Problem Description

2026/07/16 by jinxing

SQLazy：Merge Multiple Tables into Single Rows by Common ID

2026/07/15 by jinxing

SQLazy：Forward Fill NULL Values

2026/07/14 by jinxing

Code-as-Documentation: An SQL Development Paradigm for the AI Era

2026/07/10 by lisongbo

Preferred

What to use for data analysis programming, SQL, Python, or esProc SPL?

After Excel, What Data Analytics Tool Do We Need

Something Would Free Data Scientists from Heavy Coding Work

Something Could Double the Development Efficiency of Java Programmers

Data Calculation Problems Based on Object-Event Schema

Actually, Python is far beyond you

Then let’s talk about discreteness, and what are the advantages of Java over SQL?

Simple SQL Statements Only Exist in Coursebooks and Training Courses

Is SPL more difficult or easier than SQL?

Hadoop/Spark is too heavy, esProc SPL is light

How the performance improvement by orders of magnitude happened

SPL: a database language featuring easy writing and fast running

Guide

2 SPL Application Development

3 SPL Desktop Analysis

4 SPL Big Data Computing

5 SPL Learning Material

6 SPL Case&Testing

7 YModel & Data Mining

esProc

The path for programmers to learn SPL

2024/07/25 by jbx

Trae + SQLazy: A Practical Guide to Writing Complex SQL

2026/07/29 by sjr

Text2SQL Practice: what happens if you ask AI to write a few dozen lines of SQL?

2026/07/28 by ezpz

Introduction of esProc runtime environment and version upgrade

2026/03/30 by raqsoft

A Field Guide to Querying and Report Computations with SPL - 12 Expand to multiple records based on the specified rule

2025/12/15 by jinxing

A Field Guide to Querying and Report Computations with SPL - 11 Datetime sequence computations

2025/12/12 by jinxing

A Field Guide to Querying and Report Computations with SPL - 10 Order-based computations on sets of strings

2025/12/11 by jinxing

A Field Guide to Querying and Report Computations with SPL - 9 Post-grouping set operations

2025/11/27 by jinxing

A Field Guide to Querying and Report Computations with SPL - 8 Multilevel JSON computations

2025/11/26 by jinxing

A Field Guide to Querying and Report Computations with SPL - 7 Row-to-column/column-to-row transposition

2025/11/24 by jinxing

Q&A

Data Handling

2024/03/25 by Divine

Hi, wunan

2024/03/28 by Divine

How can I perform this SQL code in SPL?

2024/03/28 by Divine

How to Count Distinct Users in esProc SPL?

2024/06/11 by Divine

Unknown expression: mongo_open.

2021/04/12 by sm

httpfile 网络请求如何携带多个请求头

2025/01/20 by donghao

HowTo