SQL: Variable Prompts Using a Union
SAP Business One is built on a SQL Server database and can be queried to get relevant information quickly and easily. In this training video we will look at some SAP-Business-One-specific query syntax that will allow us to prompt for query parameters to limit our searches. This is one of the more powerful tools that can be quickly understood and utilized to really help get data to help you make better decisions quicker. In a union situation, variables can offer some really great flexibility and we walk through some specific situations and results to better understand how to get the prompt and pass-through behavior we are looking for.