Grouping Sets

torsten.strauss

Hi Redgate Team,

Wrap lines longe than does not work for GROUPING SETS
It would be good to see a well formatted Grouping Sets as well - thanks for fixing!

SELECT

wait_type

  , resource_waiter_type

  , resource_thread_id

  , resource_node_id

  , SUM (wait_duration_ms) AS wait_duration_ms

  , SUM (wait_duration_ms) / 1000000.0 AS wait_duration_seconds

  , resource_owner_activity

  , resource_waiter_activity

FROM

p_waits AS p1

GROUP BY

GROUPING SETS((wait_type, resource_thread_id, resource_node_id, resource_waiter_type, resource_owner_activity, resource_waiter_activity), (wait_type, resource_waiter_type), ())

ORDER BY

wait_type, resource_node_id, wait_duration_ms DESC;

GO

Torsten
MVP | FOG

Sujay

Hi Torsten,

We have reproduced this issue and it has been passed on to the development team. I will let you know once there is an update from them.

Regards,
Sujay

Sujay

Hi Torsten,

The development team has reviewed the bug. Unfortunately, they are unable to work on a fix for this bug based on the prioritization of existing open issues and looking at the overall impact.

Sorry for the inconvenience, but if you have any further questions or issues be sure to let us know.

Regards,
Sujay