Problem with Concat() Related Function

[msluser]

** Edit **
This question is directly related to the thread - Combining Rows-Opposite of Union.

I tried this approach but for some reason I am getting inconsistent results. When I place debug statements in the Concat function, it appears the query is processing the rows not in the order one would expect.

I expected each of the items in a group would be grouped, but it appears that the debug statement is showing they are processed sequentially which is breaking the function.

the debug shows
Group1 item1
Group1 item2
Group2 item1
Group1 item3
Group2 item2

so the results are jumbled up.

Any ideas?

[NeoPa]

You need to post a proper question that includes the informatoin that would be required to help you. At a minimum this would be the SQL you're using for your query.