A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored ...

Can you chip in? This year we’ve reached an extraordinary milestone: 1 trillion web pages preserved on the Wayback Machine. This makes us the largest public repository of internet history ever ...

Run dynamic SQL in SQL. This package allows queries with an unknown number of select-list items and can solve challenging problems like dynamic pivoting.

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...

Developers often dismiss dynamic SQL used in PL/SQL programs for two reasons. One reason is that it's riskier because the SQL statements aren't parsed until runtime, so it's more difficult to catch ...