# Execution Plan and Syntax Check **URL:** \ **Category:** Toad for SQL Server\ **Created:** [July 30, 2017, 11:32pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775 "2017-07-30T23:32:18Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![BAH\_zer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bah_zer/32/288_2.png) [@BAH\_zer](https://forums.toadworld.com/u/BAH_zer)\ **Post date:** [July 30, 2017, 11:32pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/1 "2017-07-30T23:32:18Z")
Все доброго времени суток. За время работы в вашей программе столкнулся со следующими проблемами - 1. Проценты не корректно отображаются в плане выполнения запроса. В отличии от SSMS, в планах выполнения часто указываются нулевые проценты стоимости запроса. Есть ли возможность исправить данную ошибку? 2. Нет возможности настроить систему для того что бы она корректно воспринимала пользовательские агрегатные функции. Пример - функция list. Она была добавлена в базу данных из внешней dll и используется для соединения строк. Однако если перед параметром функции list поставить ключевое слово DISTINCT, TOAD for SQL SERVER распознает его как не корректный синтаксис и выдаст множество синтаксических ошибок. Однако код является валидным и успешно выполняется. Есть ли возможность исправить данную ошибку? * * * Hello. During the work in your program faced the following problems - 1. The interest is not correctly displayed in the query execution plan. Unlike SSMS, execution plans are of zero interest cost of the query. Is there a way to fix this error? 2. There is no possibility to configure the system for that would it correctly take a user-defined aggregate functions. Example - function list. It was added to the database from an external dll and is used to join strings. However, if before the function parameter list to put the DISTINCT keyword, TOAD for SQL SERVER will recognize it as invalid syntax and will give you many syntax errors. However, the code is valid and runs successfully. Is there a way to fix this error? 3. ![Incorrect percent.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/c98795daf78729e6ed2a49961209a9db1d33dbf3.jpeg) 1. ![incorrect syntax check.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/76f08a3ada70f1b310e520ebfddef60f6c15679a.jpeg) VERSION - Toad for SQL Server 6.6.0.963 ---
**Author:** ![BAH\_zer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bah_zer/32/288_2.png) [@BAH\_zer](https://forums.toadworld.com/u/BAH_zer)\ **Post date:** [August 31, 2017, 9:20pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/2 "2017-08-31T21:20:02Z")
Any ideas? ---
**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\ **Post date:** [September 4, 2017, 12:57am UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/3 "2017-09-04T00:57:11Z")
Hi BAH–zer, Thanks for your post. Have you try to use v6.8? it seem that work fine. Regards, Michael ---
**Author:** ![BAH\_zer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bah_zer/32/288_2.png) [@BAH\_zer](https://forums.toadworld.com/u/BAH_zer)\ **Post date:** [September 7, 2017, 9:59pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/4 "2017-09-07T21:59:27Z")
Hi, this errors persists. * * * ![distinct.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f6d3189e0b893b637abe5317d46f093f3107d3f0.jpeg) 1. ![distinct.jpeg](https://global.discourse-cdn.com/quest/original/2X/f/f6d3189e0b893b637abe5317d46f093f3107d3f0.jpeg) toad\_for\_sqlserver\_2017\_x86\_trial\_full - 6.8 ---
**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\ **Post date:** [September 8, 2017, 5:19am UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/5 "2017-09-08T05:19:32Z")
Hi BAH–zer, The parser error still exists in latest parser versions. Sorry for the inconvenience it caused. It is queued for fixing (QP-2603). Thanks, Andre ---
**Author:** ![BAH\_zer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bah_zer/32/288_2.png) [@BAH\_zer](https://forums.toadworld.com/u/BAH_zer)\ **Post date:** [September 10, 2017, 8:40pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/6 "2017-09-10T20:40:07Z")
Can you say anything about percents in execution plan? ---
**Author:** ![BAH\_zer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bah_zer/32/288_2.png) [@BAH\_zer](https://forums.toadworld.com/u/BAH_zer)\ **Post date:** [August 9, 2018, 9:36pm UTC](https://forums.toadworld.com/t/execution-plan-and-syntax-check/39775/7 "2018-08-09T21:36:18Z")
Both errors remained in version Toad for SQL Server 6.8.2.9 (64 bit) ![List.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/cae6adf9f41baceaabab69241c7682b4c906f4c7.jpeg)