By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Problem with Concat() Related Function

P: 1
** 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?
Dec 15 '11 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
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.
Dec 16 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.