I have a table that stores student grades:
A student could be given multiple grades for the same course throughout the year with the TermCode being the key.
I'd like to have a SQL statement that pivots this table and returns the data horizontally like a gradebook view:
123435 AlgebraI Mr. Smith A B+ B A-
123435 History Mr. Jones C C+ B- B
The list of possible TermCodes is known so that doesn't need to be dynamic and I do only need to return the four columns of potential term grades.
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines