esProc Desktop's Blog
Tag

Databases

#databases

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

#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

#140 — Generate Continuous Arrays

Feb 7, 20251 min read

Problem description & analysis: There is a column of serial numbers (No), as shown in the figure below: Task: Now we want to use the two numbers in...

#140 — Generate Continuous Arrays

#139 — Interconversion of Rows and Columns in Reverse Order

Feb 5, 20251 min read

Problem description & analysis: Here below is a data table: Task: Now we want to transpose the M columns of a two-dimensional table to M rows, and...

#139 — Interconversion of Rows and Columns in Reverse Order