can you suggest how to make this self join more efficient?
there are 30 M records in the ABC table.
ON a.COL2 = b.COL2
a.COL1 = '112672803' AND
a.DATECOL = '2012-1-01' AND
b.COL1 <> '112672803' AND
b.DATECOL = '2012-1-01'
AND a.COL2 = '45673'
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.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…