Re: Slow concat crosstab query
I don't find that Excel useful to analyze your issue without sample raw data and the code used. Why don't you just provide db?
However, I doubt process using ConcatRelated in conjunction with CROSSTAB can be speeded up. Might have to use alternative approach, such as writing records to a 'temp' table.
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Last edited by June7; 01-14-2019 at 01:38 PM.