Yes.  Use GROUPING SETS.  If you want a more complete answer, post sample data and expected results as outlined in the first link in my signature.

This would be...

A situation came up today that really has me irked. I work for an IT consulting agency and...

They switched to using the Visual Studio regex language.  Using Regular Expressions in Visual Studio,

Drew

This also gives the expected results.

;
WITH Company_Groups AS
(
  SELECT c.*, FIRST_VALUE(c.CompanyName) OVER(PARTITION BY g.GroupNumber ORDER BY c.CompanyStatus ROWS UNBOUNDED PRECEDING) AS GroupName
 ...

Loginless Users in SQL

The two main methods are the CROSS APPLY (suggested by Piet) and the CTE/ROW_NUMBER (suggested by Sue and...

Anyone else notice that read threads are being marked unread even though there are no new posts?  I'm pretty sure that I've read everything in a thread if I'm marked...

The week between Christmas and New Year's has rarely been a slow week for me.  For most of my career, I was in fund-raising, and that week was one of...