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.
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
Last edited by June7; 01-14-2019 at 01:38 PM.