Invantive SQL is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc. Use this tag for questions about the use of Invantive SQL and make sure to add the appropriate tag for the system you are querying, like exact-online. For product use questions use Super User.
Invantive SQL is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc.
Invantive PSQL is a procedural extension on top of SQL included with Invantive SQL. Please use the tag Invantive SQL for PSQL questions.
Questions should include relevant SQL statements to reproduce the problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the databases and/or cloud-applications you are querying, like exact-online or freshdesk.
For product use questions use Super User.
If you want to ask a question about an error you get when firing a SQL statement, copy this template into your question:
Problem statement:
[explain what you want to achieve]
Steps to reproduce:
1. The first step
2. The second step
The SQL code you used (don't use images but code formatting)
Expected result: [show or explain the expected result, preferably in text]
Actual result: [show or explain the actual result, preferably in text. If you received an error, include the full error in the block below]
> [The error message]