Computer Science

This category contains pragmatic information and solutions to some complex issues I have worked out by gluing bits of information gleaned from technical sites like Stack Overflow.

SQL – Procedure and Function Callee Hierarchy

Hierarchical relationships of stored procedures, functions and tables.

SQL – Procedure and Function Caller Hierarchy

Hierarchical relationships of stored procedures, functions and tables.

SQL – Recursive CTE

How to create a recursive CTE to get hierarchical data from a table.