Another note:

I have a 2nd INSERT, which is somewhat similar:

;INSERT INTO #Grouping (CartID, GroupingNames)

SELECT c.CartID

, STUFF((SELECT '; ' + GroupName FROM CartGroups cg WHERE cg.CartID=c.CartID ORDER BY GroupName FOR XML...

Luis Cazares (2/4/2014)

---

I don't know your complete requirements, but shouldn't you be showing a lot less rows (just one per cart)? If you just want to list the Carts with...

LutzM (11/20/2013)

---

There are definitely ways to speed this process up (or at least make the code more compressed).

But you're not seriously asking in a web forum if someone could tune...