Re: Aggregate string concatenation efficiency problem

Hi John,

Now I am with you (sort of). I can't tell what is causing your
operation to run slow when you are trying to read Column5. But what I
would do for a starter is to append the data from your query to a temp
table:

Select * Into tblX From yourQuery

Now all of the query data is in the temp table which I called tblX. Try
reading column5 from this table.

Select column5 from tblx

Then try running your code against tblx instead of your query. If you
still have the same problem -- it will be much easier to figure out what
is going on because we have simplified the platform from a complex query
to a simple table.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages