A Faster BETWEEN Dates
This article shows us a different way of finding all records between 2 dates.
2010-11-01
30,057 reads
Terry Steadman
Creating Holidays and Special Dates
A way to save holiday records that can be created as needed into a search-able calendar table.
2010-08-04
13,176 reads
Blogs
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
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...
Forums
Processing Tabular model; Full vs dataOnly/calculate
Thanks if you can provide any insight. I have been performing a full refresh...
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",...
Ask SSC