esProc Desktop's Blog
Tag

data-engineering

#data-engineering

More content

Read more stories on Hashnode

Articles with this tag

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

Mar 5, 20252 min read

Problem description & analysis: The MS SQL database has an externally generated non-standard table that generates N pairs of fields and one record at...

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

Feb 25, 20252 min read

Problem description & analysis: A table in the SQL Server database can be seen as a cross table, where the combination of the first two field values...

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4