While doing some exploring, I found temp tables for BAQ reports in the SSRS reports DB, with the same “table name” and GUID. The just have a _1_
, _2_
, etc… to keep them separate.
They’re not actually duplicates. They just share the same GUID. A UNION of two of them show entirely different data
Is this an indication of a BAQ report that creates multiple RptLabels datasets?
Or is it some fail safe should the generated GUID already be in use, so GUID becomes '1_' + GUID
, '2_' + GUID
, etc…?
I’d think not, as I don’t see BAQReportResult_1_GUID, BAQReportResult_2_GUID , etc…