How can we help you today? How can we help you today?

Grouping Sets

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
torsten.strauss
0

Comments

2 comments

Sort by
  • 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
    0
  • 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

    Sujay
    0

Add comment

Please sign in to leave a comment.