esProc Desktop's Blog
Tag

coding challenge

#coding-challenge

More content

Read more stories on Hashnode

Articles with this tag

Search for the Closest Matching Record within the Group — From SQL to SPL #9

Mar 12, 20252 min read

Problem description & analysis: The table mytable in the MS SQL database has one ConfirmationStarted and multiple Closed statuses for each ID. Task:...

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

Mar 10, 20253 min read

Problem description & analysis: The id and nbr of the MS SQL database table are grouping fields. After sorting the records within the group by time...

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0

Jun 3, 20246 min read

Problem Description & analysis: There are multiple groups of data in the following Excel table. Each group has two columns, and these columns have...

In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0