It is currently stated as,
IF OBJECT_ID('@resultsSchema.@prefiXmycohort', 'U') IS NOT NULL DROP TABLE @resultsSchema.@prefiXetcohort;
where I think'@resultsSchema.@prefiXmycohort' should be '@resultsSchema.@prefiXetcohort' (notice the difference between @prefixmycohort and @prefixetcohort)
Hello, A small catch on the 1CohortCC.sql file:
It is currently stated as,
IF OBJECT_ID('@resultsSchema.@prefiXmycohort', 'U') IS NOT NULL DROP TABLE @resultsSchema.@prefiXetcohort;
where I think
'@resultsSchema.@prefiXmycohort'
should be'@resultsSchema.@prefiXetcohort'
(notice the difference between @prefixmycohort and @prefixetcohort)