Pete Cox (8/15/2013)

---

I would have thought the "order by" clause is absoutely necessary to guarantee a match to the sequence supplied as the answer. There is no implicit row order...

But why is the result (0, 1) eliminated?

Does the engine first pick cp.pkey=0 from row 1 and 2 then looks at row 3-4 to check if up.pkey matches 1 and...

Registering the dll worked for me too! Tanks a lot!!!

It also solved an issue I had with not being able to save maintenance plans.

The function CombineGroupNames() can be optimzed using this concat-logic:

DECLARE @Groups VarChar(MAX)

SELECT @groups = coalesce(@groups +'|' + G.GroupName. G.GroupName)

...