A Simple Recursion Finds Joins
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
2014-01-06
8,162 reads
Kate Luxemburg
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Forums
Converting nested Json document to SQL data
I have response from a API that look like { "responseCode": 200, "message": "success",...
Converting nested Json document to SQL data
I have response from a API that look like { "responseCode": 200, "message": "success",...
To Drop or Not to Drop (the temp table question)
So here's a thing that I've been told several times over the past few...
Ask SSC