Brandon McDowall | Hey Tommy, Let me save you a ton of time searching the web. This forum is all we have for this little CUIS niche/SQL. There is no "'enterprise skill group real time" table there is a "Skill_Group_Real_Table" which you can link to the Agent_Skill_Group_Real_Time table using the SQL below.
FROM mhrs_awdb.dbo.Agent_Skill_Group_Real_Time a inner join mhrs_awdb.dbo.Skill_Group_Member b on b.SkillGroupSkillTargetID=a.SkillGroupSkillTargetID inner join mhrs_awdb.dbo.Skill_Group c on c.SkillTargetID=b.SkillGroupSkillTargetID inner join mhrs_awdb.dbo.Skill_Group_Real_Time d on d.SkillTargetID=c.SkillTargetID
Hope that helps.
- Brandon
|
| Please sign in to flag this as inappropriate. |