search

gm5000136 / GM_Dashboards

0 stars 0 forks source link

There are 25 appeals without teams, but none with multiple teams #14

Open gm5000136 opened 9 years ago

gm5000136 commented 9 years ago

Find them with this (in BBPM):

select a.AppealIdentifier, Count(p.Team) as TeamCount from DIM_Appeal a left outer join DIM_Team p on p.TeamDimID = a.TeamDimID group by a.AppealIdentifier having Count(p.Team) <>1