What is the SQL Execute window?
The SQL Execute window offers the ability to execute Transact-SQL queries from within your Great Plains SQL version system without needing additional SQL Administration Utilities loaded. The result set can be displayed as text or as a Listview. However, one of the best features is that you can use Dexterity Technical names when writing your query and they will automatically be converted into the correct physical name for the field or table prior to execution.
