Toad World® Forums

Bug in Suggested Group By Clause when select includes a CONVERT() command on an aggregate

Suggested Group By Clause when select includes a CONVERT() command on an aggregate. This is probably true for any function that you wrap around an aggregate (which normally Toad does exclude)

Try this on AdventureWorks:

SELECT sd.SalesOrderID, CONVERT(float, SUM(LineTotal)) as Total
FROM Sales.SalesOrderDetail sd
GROUP BY sd.

Notice that Group By clause is incorrect.

Hi Darren,

Thank you. I create TSS-872 for this issue. But this may not fixed in ToadforSQLServer 6.6 Release. Sorry for your inconvenience.

Best Regards,

Kelly

It’s not an urgent bug.

Darren

On Feb 3, 2015, at 3:50 AM, Kelly.Chen bounce-KellyChen@toadworld.com wrote:

RE: Bug in Suggested Group By Clause when select includes a CONVERT() command on an aggregate

Reply by Kelly.Chen
Hi Darren,

Thank you. I create TSS-872 for this issue. But this may not fixed in ToadforSQLServer 6.6 Release. Sorry for your inconvenience.

Best Regards,

Kelly

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for SQL Server - Beta
notifications altogether.

Toad for SQL Server - Beta Discussion Forum

Flag
this post as spam/abuse.