Chandrashekar
3/15/2016 - 8:23 AM

Select-PGU SKILL Script

Select-PGU SKILL Script

SELECT cps.CenterXPGUId
		,cp.PGUId
		,p.NAME
		,cps.CenterXPGUXSkillId
		,cps.SkillId
		,s.SkillName
	FROM TCIV3_Dev.dbo.CenterXPGUXSkill cps
	INNER JOIN TCIV3_Dev.dbo.CenterXPGU cp ON cp.CenterXPGUId = cps.CenterXPGUId
	INNER JOIN TCIV3_Dev.dbo.PGU p ON cp.PGUId = p.PGUId
	INNER JOIN TCIV3_Dev.dbo.Skill s ON cps.SkillId = s.SkillId