esProc Desktop's Blog
Tag

data analytics

#data-analytics

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

#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

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

Feb 8, 20251 min read

Problem description & analysis: The values in columns A and B are natural numbers, representing the start and end points of the array...

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

#136 — Put Data in a Group Horizontally into Columns

Jan 24, 20251 min read

Problem description & analysis: Here below is a data table: Task: Rank the students by score, and arrange the names with the same score into the same...

#136 — Put Data in a Group Horizontally into Columns