Your #1 source for SAP Business One tutorial videos
Business One has updated to 9.0! Videos focusing on new features and changes are coming!
New videos uploaded covering Alerts and A/R!
Business One Training: Now with over 275 videos!
Welcome to the new Business One Training site! Please let us know if you encounter any issues.

SQL: Variable Prompts Using a Union

Thu, 02/14/2013 - 16:39 -- admin

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.