Cacher is the code snippet organizer for pro developers

SELECT a.NAME Account
	,uc.UserXCenterId
	,u.UserName
	,axps.CenterPguSkillId
	,s.SkillName
	,ucxps.Id UserSkillId
	,a2.AssessmentId
	,trs.ActivityId ATPId
	,dbo.UFN_GetATPNameByATPId(trs.ActivityId) AS AtpName
	,trs.Rating
FROM dbo.Account a
INNER JOIN dbo.AccountXUserCenterRole axcr ON axcr.IsActive = 1
	AND axcr.AccountId = a.Id
INNER JOIN dbo.UserXCenterXRole ucr ON ucr.UserXCenterXRoleId = axcr.UserCenterRoleId
	AND ucr.IsActive = 1
INNER JOIN dbo.UserXCenter uc ON ucr.UserXCenterId = uc.UserXCenterId
	AND uc.IsActive = 1
INNER JOIN dbo.[User] u ON u.UserId = uc.UserId
	AND uc.IsActive = 1
INNER JOIN dbo.AccountXCenterPguSkill axps ON axps.AccountId = a.Id
	AND axps.IsActive = 1
INNER JOIN dbo.CenterXPGUXSkill cps ON cps.CenterXPGUXSkillId = axps.CenterPguSkillId
	AND cps.IsActive = 1
INNER JOIN dbo.Skill s ON s.SkillId = cps.SkillId
	AND s.IsActive = 1
LEFT JOIN dbo.UserCenterXCenterPguSkill ucxps ON ucxps.UserXCenterId = ucr.UserXCenterId
	AND ucxps.CenterXPGUXSkillId = axps.CenterPguSkillId
	AND ucxps.IsActive = 1
LEFT JOIN dbo.Assessment a2 ON ucxps.Id = a2.UserCenterXCenterPguSkillId
	AND a2.IsActive = 1
LEFT JOIN dbo.TCIAssessmentResultSummary trs ON a2.AssessmentId = trs.AssessmentId
	AND a.IsActive = 1
WHERE a.IsActive = 1
	AND a.Id = 2