T-SQL and GROUP BY ALL

Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.

<< multi-million dollar idea... | Home | SqlBulkCopy >>

How is it possible that I'm just learning about the "GROUP BY ALL" option? It sounds like it would save a lot of time. It worries me though that Microsoft says not to use it anymore because it will be removed from a future version. Is there a good alternative?

Posted on Monday, April 9, 2007 6:37 PM all tech stuff , SQL Server | Back to top

Comments on this post: T-SQL and GROUP BY ALL

# re: T-SQL and GROUP BY ALL

When you design an SSIS package now, there's an advanced aggregate tool that really helped me finish a project quickly at Bell Mobility instead of filing up the temp database constantly. I recommend you check it out....maybe that's their future solution to group by.

Left by Hugo Shebbeare on Jul 06, 2007 4:35 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification:

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure