InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 06:40:11 GMT20http://www.sqlservercentral.com/Forums/Topic1409297-392-1.aspxEmpty set add a grand total.[url]http://www.sqlsnippets.com/en/topic-13122.html[/url]Sun, 20 Jan 2013 12:29:17 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1409297-392-1.aspxWhat does the () signify with grouping sets of multiple elements? An example on Microsoft.com, (http://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx), read the following T-SQL code:GROUP BY GROUPING SETS( (T.[Group], T.CountryRegionCode) ,(S.Name) ,(H.SalesPersonID,T.[Group]) ,(H.SalesPersonID) ,())What does the last open parenthesis and its closing parenthesis "()" mean?I think has the effect of a UNION of GROUP BY () nothing. But I don't know why you would want the results of a GROUP BY () that doesn't have any value.Sun, 20 Jan 2013 12:03:04 GMTGolfer22