esProc Desktop's Blog
Tag

Programming Blogs

#programming-blogs

More content

Read more stories on Hashnode

Articles with this tag

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Feb 21, 20252 min read

Problem description & analysis: An invoice table in the SQL Server database has one amount for each project, and each project in the project table has...

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

Feb 20, 20253 min read

Problem description & analysis: A SQL Server database table describes the execution progress of multiple operations in a production process. When the...

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

Feb 18, 20252 min read

Problem description & analysis: A certain database table describes the payment cycle for multiple projects (IDs), with one payment cycle consisting of...

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

#145 — Insert Blank Row when Meeting with Data Change

Feb 17, 20251 min read

Problem description & analysis: Here below is a data table: Task: We want to insert one blank row when the values in two adjacent rows change, the...

#145 — Insert Blank Row when Meeting with Data Change

#144 — Insert Row after Specific Row

Feb 14, 20251 min read

Problem description & analysis: Here below is a data table: Task: Insert one row after the number 100, and fill in a001, a002, … in turn, like...

#144 — Insert Row after Specific Row

#143 — Expand One Row into Multiple Rows after Splitting Text

Feb 12, 20251 min read

Problem description & analysis: The following is a data table, in which columns D and E have multiple lines of text, the number of lines is the same,...

#143 — Expand One Row into Multiple Rows after Splitting Text