Using placeholders for dynamic filenames and messages

You can use placeholders in AutoSQL to make your email messages or filenames use variables like date, time, result rows, etc. A common example is to use the {date} and {time} place holder in the output filename. Instead of overwriting the same file every day, this will create a new one each time your run … Read moreUsing placeholders for dynamic filenames and messages

How to export a SQL query to Excel and pre-define formatting

Introduction Many databases have options to export query results to Excel. Typically this is not really Excel, but just CSV and you have no option to format the output. With AutoSQL you can write your query results directly to Excel and use a template to pre-define formatting. In this example we will create a simple … Read moreHow to export a SQL query to Excel and pre-define formatting