Options
Grouping Sets
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
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!
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
MVP | FOG
Tagged:
Answers
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
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