Objects tagged with sql


← Back to the Posts

[SOLVED] Resync Postgresql tables primary key

Published on August 20, 2021 at 05:37AM

ERROR: duplicate key value violates unique constraint

Blank Power Query Template for a Raw SQL Query using Microsoft SQL Server

Published on May 24, 2021 at 03:57AM

You want to send raw sql from Power Query to your SQL Server database so you can do better query folding than Excel.

MySQL Convert Datetime field in UTC Timezone to Brisbane Australia

Published on August 21, 2020 at 01:27AM

CONVERT_TZ() makes you happy to keep your server on UTC while you sit in Brisbane eating Yatala Pie

Extract Multiple Product Hierarchy Levels from an SAP Product Hierarchy Key

Published on August 19, 2020 at 01:02AM

SAP Product Hierarchy 0101010101 maps to Level 1 **01**, Level 2 **0101**, Level 3 **010101** Level 4 **01010101** and Level 5 **01010101**

Using SQL to Convert Date to Financial Period Key

Published on August 18, 2020 at 11:59PM

Taking a Date (ie 1st July 2020) and converting it to Financial Period Key (ie 202001). Built for Australia style Financial Year

Blank Power Query Template for a Raw SQL Query

Published on June 15, 2020 at 01:23AM

You want to send raw sql from Power Query to your database because you're better at query folding than Excel.

Rails new with Webpacker, Vue and Postgres

Published on December 12, 2018 at 04:14AM

I always forget my last process for starting a greenfield rails app

[SOLVED] SQL Get Financial Year from Date

Published on February 07, 2018 at 12:21AM

This example will return the Financial Year for today's date. This can then be set to a variable to be used in another query

Using VS Code Extension MSSQL instead of Excel Power Query for Easy Database Querying

Published on February 07, 2018 at 12:01AM

Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.

Display a SQL Server Table Schema in PowerBI

Published on May 03, 2017 at 04:33AM

This was useful when building a subsequent M Query and needed to know all available table column, types and keys

Cheatsheet for Running SQL Against PostgreSQL from the Command Line

Published on April 06, 2017 at 02:41AM

I am using psql to interact with a PostgreSQL database from the command line and I don't know what I am doing :P


← Back to the Screenasts
There are no casts tagged with sql