SSRS temp table "duplicates"

Epicor ERP 10
1

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.

image

They’re not actually duplicates. They just share the same GUID. A UNION of two of them show entirely different data

image

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…

2

UPDATE

It seems that only the RptLabels_xxxxx tables have multiple tables with the same GUID. And they all seem to be for Reports related to Orders.

3

I believe all those tables are then joined/ Union-ed in to a View with the same GUID…