esProc Desktop's Blog

esProc Desktop's Blog

Follow

Follow

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

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

Problem description & analysis: A SQL Server database table describes the execution progress of multiple operations in a production process. When the Outcome of an OP is 0, it indicates execution failure and should continue until the Outcome is 1. Th...

esProc Desktop

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

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

esProc Desktop

#145 — Insert Blank Row when Meeting with Data Change

#145 — Insert Blank Row when Meeting with Data Change

esProc Desktop

#144 — Insert Row after Specific Row

#144 — Insert Row after Specific Row

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

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

#142 — Expand One Row into Multiple Rows Based on Value

#142 — Expand One Row into Multiple Rows Based on Value

#141 — Generate Continuous Arrays — Concatenate Results into a String

#141 — Generate Continuous Arrays — Concatenate Results into a String

#140 — Generate Continuous Arrays

#140 — Generate Continuous Arrays

#139 — Interconversion of Rows and Columns in Reverse Order

#139 — Interconversion of Rows and Columns in Reverse Order

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

#137 — Re-group or Sort When Filling Grouped Data into Columns

#137 — Re-group or Sort When Filling Grouped Data into Columns

#136 — Put Data in a Group Horizontally into Columns

#136 — Put Data in a Group Horizontally into Columns