In Toad for Data Analysts 2.5 Automation Variables were added which greatly expanded what you could accomplish in an automation script. Variables can be used in almost every activity. This post lightl...
The Query Builder in Toad Data Point allows you to enter a SELECT statement in the Query tab and reverse engineer it into a visual representation on the Diagram tab. This can be very useful when migra...
If there’s one thing that people ask me it’s “How can I use Toad for Data Analysts to automatically update my Excel report?” I’ll show you how you can get your Excel reports to update from the databas...
I thought for today we could spend a few minutes on what users may benefit the most from Toad’s cousin, Toad Data Point. This blog will concentrate on working with SQL. 1. SQL Recall The time you’ve ...
Often when writing a query you need to get data from a range of dates; when you start thinking about automating the SQL query it’s even more important. In this post I’ll show you a quick trick to let ...
