New training course: Customizing SQL Prompt. Watch now.

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

Answers

  • 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
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
  • 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

    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
Sign In or Register to comment.