Re: Aggregate string concatenation efficiency problem

What we want to check by creating a query that only retrieves the data
for column5 is this:

1) does this query of only column5 run OK by itself?
2) does this query run a make table query OK?

If 2) has slow results like the original query, then we need to look at
your function and see what we can improve on. Could you show the code
for your function? and then show how you invoke it?


Select yourFunction(arg1, arg2, ...) As column5 From tblwhatever Join
tblwhatever2 On ... Where...

Public Sub yourFunction(arg1, arg2, ...)
...
End Function




Rich

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

Relevant Pages